Be gentle as I come from an Oracle background a long time ago.
I am trying to join several tables with a couple of tables having a one
to many relationship.  I got one query working pretty well but the issue
comes about when I add one more table with a one-to-one relationship.  I

struggling around with this for some time:
How can I use a table name as a parameter in a PL/pgSQL function ??
I tried this but it didn't work...
CREATE OR REPLACE FUNCTION my_row_count(text) RETURNS int4 AS '

I wanted to involve in Postgres beta testing. I want to the test the Windows
Beta version.
I have downloaded the below
ftp://ftp4.ar.postgresql.org/pub/mirrors/postgresql/win32/postgresql-8.0.0-beta4.zip

Check her out and let me know if there are any problems ... I've changed
the mk script to pull in the beta3 man pages that I found  in the dev/doc
directory ...
----

I got extremely frustrated with having to create a temp table every time
I wanted to access an arbitrary column from a record plpgsql. After
seeing a note on the developers TODO about accessing plpgsql records
with a 'dot bracket' notation I started digging into the plpgsql source.

I guess the subject says it all, can I install the
B5 release to a B4 db without starting from scratch?
Jerry
---------------------------(end of broadcast)---------------------------

Folks,
Two possible bugs.
#1 Loading unicode data.
#2 Doing count of data based on substring(1,1) of a col.

OK, getting closer.  The error happens if in jdbc I reuse
PreparedStatement objects to reexecute the same set of queries multiple
times.  Specifically if I do the following set of queries:
Declare cursor

I´m not DBA. I´m a infrastruture professional, please someone help me
In my company we have a PGSQL Linux Red Hat 9 Database
The relevant portions of my DB Backup Script follows
I can send too, the whole script with other parts of the code

I have a table with a timestamp column and I want to set this to a value
of now() - a random number of days between 0 and 45 for each row... I've
tried to do this a bunch of different ways and can't figure it out...
Here is my latest version:

I have three questions about 1 table
CREATE TABLE public.logs
(
 rule_name varchar(32) NOT NULL,

Is it possible for the COPY command to read data from a file, but skip
specific columns?
Thanks
Adam

Hello I have a doubt regarding Image insert into Postgres DB.
Yesterday i posted a query regarding this. and this one is in
continuation.
I am working on Project with Linux Server and Windows Client

The following bug has been logged online:
Bug reference:      1320
Logged by:          Simon Riggs
Email address:      simon@2ndquadrant.com