Subselects not allowed?

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Subselects not allowed?
Date: 2011-06-11 15:01:54
Message-ID: 201106111701.54145.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Can anybody tell me why this doesn't work?

pgslekt=> CREATE SEQUENCE sources_source_id_seq START WITH (SELECT
MAX(source_id) FROM sources);
ERROR: syntax error at or near "("
LINE 1: CREATE SEQUENCE sources_source_id_seq START WITH (SELECT MAX...
^
pgslekt=>

regards, Leif

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Guillaume Lelarge 2011-06-11 15:08:12 Re: Subselects not allowed?
Previous Message Jasen Betts 2011-06-11 09:59:42 Re: ANY for Array value check