I am getting this error
postgres=# \i a.sql
psql:a.sql:10: ERROR: parser: parse error at or near "return" at character
26
--
a.sql
--
create function loadme() return text as '
Declare
s_out text ;
Begin
For i in 1..1 loop
insert into test values (i,''Test'');
end loop;
return s_
-
plpgsql | t
(1 row)
Can u pls advice if u know whats going on.. Am I missing somin obvious here.
..
Thx in advance
Deep
-Original Message-
From: Doug McNaught,,, [mailto:[EMAIL PROTECTED] On Behalf Of Doug
McNaught
Sent: Monday, January 12, 2004 4:44 PM
To: Thapliyal, Deepak
C
ral
Subject: Re: [GENERAL] Parse error help needed...
Thapliyal, Deepak wrote:
> create function loadme() return text as '
try "RETURNS" instead of "RETURN"
[the guys writing the function parser might want to consider reporting
what the parser was expecting at this point
om: Larry Rosenman [mailto:[EMAIL PROTECTED]
Sent: Monday, January 12, 2004 5:29 PM
To: Thapliyal, Deepak; 'PostgreSQL General'
Subject: Re: [GENERAL] Parse error help needed...
--On Monday, January 12, 2004 17:24:14 -0800 "Thapliyal, Deepak"
<[EMAIL PROTECTED]> wro
Hi,
Assume I have a bank app.. When customer withdraws $10 from his accouint I
have to do following
--> update account_summary table [subtract $10 from his account]
--> update account detail_table [with other transaction details]
Requirement:
either both transactions sho
Can I use a "set transaction" type mechanism within a function?
thx
Deep
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 10:17 AM
To: Thapliyal, Deepak
Cc: 'Richard Huxton'; [EMAIL PROTECTED];
[EMAIL PROTECTED]
S
Hi Guys,
Do you know any companies in the San Diego Area(or nearby) who can give
consulting expertise. This is for getting us up and running with postGresql
I would appreciate if I can get emails addresses/compnaies names who do this
..
Thx
Deep
-Original Message-
From: [EMAIL PROTECTE
