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
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
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]
Subject: Re: [GENERAL
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
(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
Cc: '[EMAIL PROTECTED
...
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]
Declare
s_out text ;
Begin
For i in 1..1 loop
insert into test
: 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] wrote:
Made the change and used returns in both places now .. Gives me error
postgres