Thread: how to use pgsql like mssql

<br /><br /><pre wrap="">in the pgadmin edit<br />i want use<br />declare  ...<br />if exists ...<br />insert something
if@@rowcout>0 then do something<br />if ....<br />like in mssql and not use function<br />how to<br />sorry for my
english</pre><br/><br /><br /><br /><span id="spnSignFirst"></span><span id="spnSign"></span><br /><br /> 

--- On Wed, 12/26/07, liuzg2@21cn.com <liuzg2@21cn.com> wrote:

> in the pgadmin edit
> i want use
> declare  ...
> if exists ...
> insert something if @@rowcout>0 then do something
> if ....
> like in mssql and not use function


I take it that you are looking to create stored procedures?  In postgresql they are called "stored functions" or more
correctly"functions."
 

First you will need to load a procedural language into your database if one isn't already installed.
http://www.postgresql.org/docs/8.2/interactive/sql-createlanguage.html

You should probably use PLpgSQL since it is available across OS all platforms and is easy to learn and use.

http://www.postgresql.org/docs/8.2/interactive/plpgsql.html

There are some nice examples in this documentation.

Your PGadmin will also have features to help the create these functions also.

Regards,
Richard Broersma Jr.

<br /><br />but  i do not   want use function  or  procedure  <br /><br />wish this features<br /><br /><br /><span
id="spnSignFirst"></span><spanid="spnSign"></span><br /><br /> 

--- On Wed, 12/26/07, liuzg2@21cn.com <liuzg2@21cn.com> wrote:

> but  i do not   want use function  or  procedure  


Are you sure?  I thought that:

DECLARE
IF --control structures
@@rowcount

where only usable in a store procedure.  Am I incorrect, or are these keywords accessible from the SQL prompt?

Regards,
Richard Broersma Jr.

On 27/12/2007, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> --- On Wed, 12/26/07, liuzg2@21cn.com <liuzg2@21cn.com> wrote:
>
> > but  i do not   want use function  or  procedure
>
>
> Are you sure?  I thought that:
>
> DECLARE
> IF --control structures
> @@rowcount
>
> where only usable in a store procedure.  Am I incorrect, or are these keywords accessible from the SQL prompt?
>

You can use outside procedure in T-SQL.

Pavel

> Regards,
> Richard Broersma Jr.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

Hello

On 27/12/2007, liuzg2@21cn.com <liuzg2@21cn.com> wrote:
>
>
> but  i do not   want use function  or  procedure
>
> wish this features
>

PostgreSQL doesn't support this feature. You can use procedural
construct only in functions.

Regards
Pavel Stehule

>
>
>
>