Re: Using column references in default expression

Oliver Elphick was kind enough to tell me about using function results as
default values offlist. That was what I was looking for.

Thanks again,

Max

Maximilian Tyrtania | IT-Entwickler
Mty(at)fischerAppelt(dot)de
fischerAppelt Kommunikation GmbH
Friedichstr. 149 | D-10117 Berlin | Germany
Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
www.fischerAppelt.de

>
> Hi there,
>
> I'm in the process of moving a rather large OpenBase database to PG 8.2.3.
>
> In Openbase it was allowed to use column references in default expression,
> which seems to be forbidden in PG.
>
> You know, like that:
>
> create table Mitarbeiter_Benutzergruppen (
> _rowid longlong PRIMARY KEY DEFAULT nextval('serial') ,
> Mitarbeiter_id longlong index,
> Benutzergruppe_id longlong INDEX ,
> Unique_id varchar(1023) INDEX derived Benutzergruppe_id+':'+Mitarbeiter_id
> )