-
From: Osvaldo Kussama [mailto:osvaldo.kuss...@gmail.com]
Sent: Wednesday, January 27, 2010 11:57 AM
To: Aycock, Jeff R.
Subject: Re: [GENERAL] syntax error during function call
2010/1/27 Aycock, Jeff R. :
> Hello,
>
>
>
> I have a function with three parameters that would populate
Thanks for the catch.
However, this did not fix the syntax error.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Wednesday, January 27, 2010 11:47 AM
To: Aycock, Jeff R.
Cc: Pavel Stehule; pgsql-general@postgresql.org
Subject: Re: [GENERAL] syntax error
Adrian,
I tried that as well and got the same error result.
Regards,
Jeff Aycock
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Wednesday, January 27, 2010 11:33 AM
To: Aycock, Jeff R.
Cc: Pavel Stehule; pgsql-general@postgresql.org
Subject: Re: [GENERAL
s still giving me the same syntax error as before. I must be
missing something here though.
Thanks for the suggestion, however.
Regards,
Jeff Aycock
-Original Message-
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Wednesday, January 27, 2010 11:13 AM
To: Aycock, Jeff R
010 11:00 AM
To: Aycock, Jeff R.
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] syntax error during function call
On 27/01/2010 15:40, Aycock, Jeff R. wrote:
> BEGIN
>
> FOR r IN SELECT * FROM schema_1.snapshot_table
>
> LOOP
>
>
>
> DE
Hello,
I have a function with three parameters that would populate a table in
one schema from another table of the same name in another schema. The
tables are dynamically selected at execution time.
CREATE OR REPLACE FUNCTION schema_1.getAllSnapShot(user_id text,
begin_dt date, end_dt date
Hello,
I'm using postgresql_autodoc tool (v. 1.40) to document Postgresql 8.4
databases and have a couple of questions. This tool works great in
documenting all of the database objects with the exception of triggers
and permissions. I can see in the Perl script where permissions
information a