Στις Wednesday 17 February 2010 17:27:11 ο/η Tom Lane έγραψε:
> silly sad writes:
> > may i ask? when this feature will be fixed?
> > (now i am using 8.3.9)
>
> The example works fine for me in 8.4.
Same for me,
postg...@smadevnew:~>
postg...@smadevnew:~> psql
psql (8.4.1)
Type "help" for help.
silly sad writes:
> may i ask? when this feature will be fixed?
> (now i am using 8.3.9)
The example works fine for me in 8.4.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
2010/2/17 silly sad :
> On 02/17/10 13:51, Jasen Betts wrote:
>>
>> On 2010-02-17, silly sad wrote:
>>>
>>> acc=>
>>>
>>> CREATE OR REPLACE FUNCTION add_user (TEXT, TEXT, TEXT, TEXT)
>>> RETURNS usr AS $$
>>> INSERT INTO usr (login,pass,name,email) VALUES ($1,$2,$3,$4)
>>> RETURNING usr.*;
>
On 02/17/10 13:51, Jasen Betts wrote:
On 2010-02-17, silly sad wrote:
acc=>
CREATE OR REPLACE FUNCTION add_user (TEXT, TEXT, TEXT, TEXT)
RETURNS usr AS $$
INSERT INTO usr (login,pass,name,email) VALUES ($1,$2,$3,$4)
RETURNING usr.*;
$$ LANGUAGE sql SECURITY DEFINER;
acc=>
ERROR: re
On 2010-02-17, silly sad wrote:
>
> acc=>
>
> CREATE OR REPLACE FUNCTION add_user (TEXT, TEXT, TEXT, TEXT)
> RETURNS usr AS $$
>INSERT INTO usr (login,pass,name,email) VALUES ($1,$2,$3,$4)
>RETURNING usr.*;
> $$ LANGUAGE sql SECURITY DEFINER;
>
> acc=>
>
> ERROR: return type mismatch in f
acc=>
CREATE OR REPLACE FUNCTION add_user (TEXT, TEXT, TEXT, TEXT)
RETURNS usr AS $$
INSERT INTO usr (login,pass,name,email) VALUES ($1,$2,$3,$4)
RETURNING usr.*;
$$ LANGUAGE sql SECURITY DEFINER;
acc=>
ERROR: return type mismatch in function declared to return usr
DETAIL: Function's fin
