pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Leif Biberg Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Subselects not allowed?
Date: Sat, 11 Jun 2011 17:01:54 +0200
Message-ID: <201106111701.54145.leif@solumslekt.org> (raw)

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



view thread (10+ messages)  latest in thread

Message-ID: <201106111701.54145.leif@solumslekt.org>
Permalink:  ../201106111701.54145.leif@solumslekt.org/
Also on:    postgresql.org/message-id/201106111701.54145.leif@solumslekt.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: leif@solumslekt.org
  Subject: Re: Subselects not allowed?
  In-Reply-To: <201106111701.54145.leif@solumslekt.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox