Pl/pgsql function

From: Nick Raj <nickrajjain(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Pl/pgsql function
Date: 2011-06-04 14:04:25
Message-ID: BANLkTikjmFrm9CONfoNEgm8gGLPRmnxL0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am implementing some pl/pgsql functions.

Is there any way to change the input
for example- I got some value by $1. I want to modify this value (means
split that value), Can we do this and how?

Second thing,
Suppose i defined a function test as

select test('geom',the_geom,time) from tablename
.....
Inside body,
How can i get the tablename inside the body (because i haven't pass table
name to function)
......
end

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2011-06-04 14:22:16 Re: Pl/pgsql function
Previous Message Jon Smark 2011-06-04 11:12:04 Converting an hstore into a key/value record