| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Implementing replace function |
| Date: | 2010-10-31 17:39:17 |
| Message-ID: | 4CCDA9C5.7010409@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 31/10/2010 17:28, Alexander Farber wrote:
> I've created a function now (below) and can call it as well,
> but how can I see it at the psql prompt? Is there a \d command
> for that or should I dump the database to see my declarations?
You can do \df public.*, assuming that your function is in the public
schema, to get a list of all functions; and \df+ <function name> will
give you the function body also.
\? is your friend here.
> And is my function atomic? I.e. can't it happen, that FOUND
> is not true, but then another session calls a INSERT inbetween?
Yes - all functions are executed in an implicit transaction.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-10-31 18:47:48 | Re: max_fsm_pages increase |
| Previous Message | Rob Sargent | 2010-10-31 17:34:49 | Re: Implementing replace function |