Skip site navigation (1) Skip section navigation (2)

Re: Tuning queries inside a function

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>,pgsql general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tuning queries inside a function
Date: 2005-05-02 16:46:47
Message-ID: 42765977.4020906@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
Mike Nolan wrote:
>>select * from foo('bar','debug')
> 
> 
> But how do I do that inside a pl/pgsql function?  'select into' doesn't
> seem to work properly.


You would have to code it. For example:

IF $2 = ''debug'' THEN:
>  
> 
>>I would have to check be able to include a timestamp at the beginning
>>of each notice.
> 
> 
> You can do that from the config file, but it only gives the time to the 
> nearest second, which may not be a fine enough time interval.
> --
> Mike Nolan


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2005-05-02 16:47:18
Subject: Re: 7.3.9 Install Question - init.d/postgresql error?
Previous:From: Tom LaneDate: 2005-05-02 16:34:17
Subject: Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group