Hello, I'm trying to write a pl/pgsql function that takes in a column
(setof?) of text values and returns an english language list, for example:
if "select towns from towns_table;" retuned
town1
town2
town3
I want the following:
select column_to_english_list( select towns from towns_table );
t
Hopefully this is an easy one and sorry if I should have found this in
the docs somewhere but a cursory glance didn't turn anything up.
How do I tell how old my database is, that is, when was create db for
this database done?
Thank you,
Matthew O'Connor
--
Sent via pgsql-sql mailing list (p
Stephan Szabo wrote:
On Wed, 7 May 2008, Matthew T. O'Connor wrote:
But I would really like to be able to combine it with other data and get
a result set that looked like:
f.id, f.name, tms_summary.col1, tms_summary.col2 ...
Well I think
select f.id, f.name, (tms.get_tms_su
Hello,
I have a pl/pgsql function, defined as:
CREATE FUNCTION tms.get_tms_summary(id integer)
RETURNS tms.tms_summary
get_tms_summary returns a composite type, tms_summary, which is
comprised of several numerics.
What I would like to do is something like:
select f.id, f.name, tms.get_tms
I'm sorry if this is has been discussed, but I tried to find the answer
in the archives and failed, so...
How do I find all the rows in other tables that reference a specific row
in another table? I'm only trying to find rows that are in tables where
there is a Foreign Key referencing the pri
Ezequias Rodrigues da Rocha wrote:
It is possible to set this up on PgAdmin ?
I don't know.
I need to shutdown the postgresql service to change this parameters ?
No, you can just modify the params in postgresql.conf and HUP the server
so that it re-reads the config file, no restart require
