From: Richard Huxton <dev@archonet.com>
To: Richard Sydney-Smith <richard@ibisaustralia.com>
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How do I replace select ... into commands?
Date: Fri, 12 Sep 2003 08:08:22 +0100 (BST)
Message-ID: <49234.192.168.1.32.1063350502.squirrel@mainbox.archonet.com> (raw)
In-Reply-To: <001d01c378d9$d8a8bfc0$df6c32d2@athlon2000>
References: <20030911194512.Q47864-100000@megazone.bigpanda.com>
<001d01c378d9$d8a8bfc0$df6c32d2@athlon2000>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, richard@ibisaustralia.com, sszabo@megazone.bigpanda.com
Subject: Re: How do I replace select ... into commands?
In-Reply-To: <49234.192.168.1.32.1063350502.squirrel@mainbox.archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox