Postgres Pro
Downloads
Home   >   mailing lists

Re: how do the pro's do this? (still a newbie) - Mailing list pgsql-general

From Gunnar Lindholm
Subject Re: how do the pro's do this? (still a newbie)
Date
Msg-id 01110320143403.11809@fire
Whole thread Raw
In response to Re: how do the pro's do this? (still a newbie)  ("Command Prompt, Inc." <pgsql-general@commandprompt.com>)
List pgsql-general
Tree view 
> 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\');
Thanks, that worked.
Gunnar.
----
gunix.mine.nu   - always under destruction

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE TYPE delimiter?
Next
From: "Command Prompt, Inc."
Date:
Subject: Re: CREATE TYPE delimiter?