Re: How do I replace select ... into commands? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: How do I replace select ... into commands?
Date
Msg-id 49234.192.168.1.32.1063350502.squirrel@mainbox.archonet.com
Whole thread Raw
In response to Re: How do I replace select ... into commands?  ("Richard Sydney-Smith" <richard@ibisaustralia.com>)
List pgsql-sql
> Stephen replied :
>
>> Something like the above should work, what's the exact function and
>> error
>> message and what version are you using?
>>
>>
> thanks Stephen.
>
> Exact function definition follows:
> PG Version is 7.3.1 on Windows 2000

> select "max"(seq_val) as m into lastrsn from fseqkeys where seq_key = tbl;

Slight change of syntax needed: select into recordvar max(seq_val) from ...

- Richard Huxton


pgsql-sql by date:

Previous
From: sad
Date:
Subject: how to call a function with row-type arg
Next
From: "Richard Hall"
Date:
Subject: Re: how to call a function with row-type arg