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

help / color / mirror / Atom feed
From: Elliot <yields.falsehood@gmail.com>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
To: Kevin Grittner <kgrittn@ymail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: checking if sequence exists
Date: Fri, 15 Nov 2013 16:13:05 -0500
Message-ID: <52868E61.1000806@gmail.com> (raw)
In-Reply-To: <1384549763.68859.YahooMailNeo@web125005.mail.ne1.yahoo.com>
References: <CA+yMuNq+unyKgCrpfmmb2WK0=toMzqrx7491n=upM8Rrj3KtwQ@mail.gmail.com>
	<CAKoxK+5DvJYF3tor6=kJKdfhpxoui6PAFjuhy9WzHjZbngGDPQ@mail.gmail.com>
	<CA+yMuNqxZu+xZeGiD-fdC+QZK-x9+zg03X8xzDpBvQcVTncYxg@mail.gmail.com>
	<1384543840.72953.YahooMailNeo@web125002.mail.ne1.yahoo.com>
	<1384544163.79352.YahooMailNeo@web125002.mail.ne1.yahoo.com>
	<1384545985.96990.YahooMailNeo@web162906.mail.bf1.yahoo.com>
	<1384549763.68859.YahooMailNeo@web125005.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

On 2013-11-15 16:09, Thara Vadakkeveedu wrote:
> "First, is this code in a plpgsql contex"?
> No, that is my problem.
> Does it have to be inside a Create function block or can justwrapping 
> the if  with a BEGIN END; suffice ?
>
Control structures like if statements don't exist in straight sql - you 
need a procedural language like pl/pgsql for that. Wrapping sql 
statements in begin/end only affects the transactional context of the 
statements, it does not cause them to be interpreted as pl/pgsql. You 
can either create a function or you can use a "DO" block, which is 
sometimes what I use for deploy scripts 
[http://www.postgresql.org/docs/9.3/static/sql-do.html].

view thread (12+ messages)  latest in thread

Message-ID: <52868E61.1000806@gmail.com>
Permalink:  ../52868E61.1000806@gmail.com/
Also on:    postgresql.org/message-id/52868E61.1000806@gmail.com

 · 

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-admin@postgresql.org
  Cc: yields.falsehood@gmail.com, tharagv@yahoo.com, kgrittn@ymail.com
  Subject: Re: checking if sequence exists
  In-Reply-To: <52868E61.1000806@gmail.com>

* 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