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

help / color / mirror / Atom feed
From: Kevin Grittner <kgrittn@ymail.com>
To: Thara Vadakkeveedu <tharagv@yahoo.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: checking if sequence exists
Date: Fri, 15 Nov 2013 18:43:59 -0800 (PST)
Message-ID: <1384569839.58633.YahooMailNeo@web162903.mail.bf1.yahoo.com> (raw)
In-Reply-To: <1384556193.7870.YahooMailNeo@web125001.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>
	<52868E61.1000806@gmail.com>
	<1384556193.7870.YahooMailNeo@web125001.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Thara Vadakkeveedu <tharagv@yahoo.com> wrote:

> By itself this sql works:

> SELECT 0 FROM pg_class
>              WHERE relkind = 'S'
>                AND oid = ('public.' || quote_ident('hibernate_sequence'))::regclass;
>
> However when I create a function for it and run it I see an error
> 
> create function chk_sequence() returns integer as $$
> BEGIN
> IF EXISTS (SELECT 1 FROM pg_class
>              WHERE relkind = 'S'
>              AND oid = ('public.' || quote_ident('hibernate_sequence')))::regclass
>   THEN
>         return 1;
>   ELSE
>  return 0;
>     END IF;
> END;
> $$ language plpgsql;

Move the cast to regclass inside one level of parentheses.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (12+ messages)  latest in thread

Message-ID: <1384569839.58633.YahooMailNeo@web162903.mail.bf1.yahoo.com>
Permalink:  ../1384569839.58633.YahooMailNeo@web162903.mail.bf1.yahoo.com/
Also on:    postgresql.org/message-id/1384569839.58633.YahooMailNeo@web162903.mail.bf1.yahoo.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: kgrittn@ymail.com, tharagv@yahoo.com
  Subject: Re: checking if sequence exists
  In-Reply-To: <1384569839.58633.YahooMailNeo@web162903.mail.bf1.yahoo.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