Re: how do the pro's do this? (still a newbie)

On Sat, 3 Nov 2001, Gunnar Lindholm wrote:
>>Well, my only suggestion is:
>>> ivad := nextval("vad_seq");
>> ^^^^^^^^^
>>Should the name be in single quotes?
>Then I get this error...
>ERROR: parser: parse error at or near "vad_seq"
>so there is something I've done wrong, but I can't see....

Are you escaping the single quotes properly? Remember that your PL/pgSQL
function definition is itself bound by single quotes, so inside the code
definition for CREATE FUNCTION that line should look like:

ivad := nextval(''vad_seq'');
or even:
ivad := nextval(\'vad_seq\');

Regards,
Jw.
--
jlx(at)commandprompt(dot)com
by way of pgsql-general(at)commandprompt(dot)com