Re: [GENERAL] Functions

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "c k" <shreeseva(dot)learning(at)gmail(dot)com>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] Functions
Date: 2008-09-15 17:57:19
Message-ID: dcc563d10809151057r3a76027ao562a79dc8c051fd2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Mon, Sep 15, 2008 at 11:53 AM, c k <shreeseva(dot)learning(at)gmail(dot)com> wrote:
>
>
> If I have a function having:
> begin
> insert into something ...
> select max(primary key) from something..
> end;
>
> does the second statement within a function can view the results after
> execution of first statement to get max(P.K.)?

Yep.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-09-15 18:58:02 Re: open source ERD for postgresql database
Previous Message c k 2008-09-15 17:53:09 Re: [GENERAL] Functions

Browse pgsql-general by date

  From Date Subject
Next Message Randal T. Rioux 2008-09-15 18:15:40 Re: [LIKELY_SPAM]Re: Oracle and Postgresql
Previous Message c k 2008-09-15 17:53:09 Re: [GENERAL] Functions