Re: [SQL] CREATE TABLE

On Thu, 25 Feb 1999, Ingrith Andrea Correa Vargas wrote:

>
> Hello!

Hola Ingrith

>
> I have a question:
>
> I want to create a table with a column wich will have a DEFAULT
> user-function value.
> Can you write an example, with the right syntax?!
>
> I have been making some examples, but I always have a syntax error that I
> can't solve.
>
> Thank you in advance, and I'll be waiting for a response!

This an example of what you want
create sequence seq_master;
create table master ( id int default (nextval('seq_master')));

Obviously, 'nextval' is not a user defined function, but i guess you can
use one of yours.

NOTICE: I'm using PGSQL 6.3-2

Suerte.

David Martinez Cuevas
Office 622-60-72 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Home 565-25-17 "Eat Linux, Drink Linux... SMOKE LINUX "
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@