Re: [SQL] Use "CREATE USER" in plpgsql function

Hi, On 15 September 2010 08:05, Tatarnikov Alexander wrote: > Hello! > > I have function wich check user credentials and if test passed function must > create new user with generated username and password. > > Language is plpgsql. > > so question is how to "unembrace" this parameter (i mean creds

[SQL] Use "CREATE USER" in plpgsql function

Hello! I have function wich check user credentials and if test passed function must create new user with generated username and password. Language is plpgsql. For example: DECLARE creds RECORD; ... SELECT * INTO creds FROM ... creds is Record with fields userName(VARCHAR) and userPassword

Re: [SQL] 9.0rc1 - query of view produces unexpected results

Nathan Grange writes: >> Or if this is a bug with 9.0, what actions do I take to make the >> PostgreSQL team awares? I think you already did ;-) regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http:/

Re: [SQL] 9.0rc1 - query of view produces unexpected results

Doh!! Files attached this time. On 09/11/2010 07:31 PM, Nathan Grange wrote: Hello list, I don't know if it's me, or maybe even the way I designed these dependencies, but I'm getting unexpected results when i query a specific view. I can only reproduce the unexpected results with a very sp

Re: [SQL] Question regarding indices

Steve wrote: Original-Nachricht Datum: Sat, 11 Sep 2010 11:08:00 -0400 Von: Lew An: pgsql-sql@postgresql.org Betreff: Re: [SQL] Question regarding indices On 09/11/2010 08:29 AM, Steve wrote: I have a small question about the order of values in a query. Assume I have a tab