On Wed, 27 Jul 2005, Dawid Kuroczko wrote:
> Hello. I was just wondering, assume we have such tables:
>
> CREATE TABLE data (
>foo text,
>somename_id integer not null references (somenames)
> );
>
> CREATE TABLE somenames (
>somename_id serial PRIMARY KEY
>somename text NOT NULL
>
Am Mittwoch, den 27.07.2005, 10:40 +0200 schrieb Dawid Kuroczko:
> Hello. I was just wondering, assume we have such tables:
>
> CREATE TABLE data (
>foo text,
>somename_id integer not null references (somenames)
> );
>
> CREATE TABLE somenames (
>somename_id serial PRIMARY KEY
>s
Hello. I was just wondering, assume we have such tables:
CREATE TABLE data (
foo text,
somename_id integer not null references (somenames)
);
CREATE TABLE somenames (
somename_id serial PRIMARY KEY
somename text NOT NULL
);
And a view:
CREATE someview AS SELECT foo,somename FROM da