Quick Links

Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites

Conditional Statement

From:	Samik Raychauhduri <samik(at)cae(dot)wisc(dot)edu>
To:	pgsql general <pgsql-general(at)postgresql(dot)org>
Subject:	Conditional Statement
Date:	2002-03-04 01:13:48
Message-ID:	3C82CA4C.6030205@cae.wisc.edu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hello,
I am trying to write a piece of SQL code, which will first check if a
table exist, drop it and then recreate it. I didn't see any 'IF' syntax
in pgsql. Is there any other alternative? I tried to use 'case'
structure, but didn't succeed.
Thanks and regards.
-Samik

Responses

Re: Conditional Statement at 2002-03-04 03:27:17 from Medi Montaseri
Re: Conditional Statement at 2002-03-05 00:54:29 from Lee Harr
Re: Conditional Statement at 2002-03-06 06:20:09 from Marshall Spight

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2002-03-04 02:20:51	Re: April 1
Previous Message	Andrew Bartley	2002-03-04 01:05:42	April 1