Re: [SQL] Function description

2008-02-15 Thread Bart Degryse
>>> Gavin 'Beau' Baumanis <[EMAIL PROTECTED]> 2008-02-15 13:33 >>> >I MUST have a local / development database for testing and educational / >learning purposes - unless of course you would like me to use the production >server for testing? I do have a development database, but not locally. And

Re: [SQL] Function description

2008-02-15 Thread Gavin 'Beau' Baumanis
Bart, You just need to put forward an appropriate case. It isn't a case of I would like these things. It is, I MUST have these things in order to perform my job. I MUST have a local / development database for testing and educational / learning purposes - unless of course you would like me to

Re: [SQL] Function description

2008-02-15 Thread Bart Degryse
>>> Gavin 'Beau' Baumanis <[EMAIL PROTECTED]> 2008-02-15 12:46 >>> >The windows installer, available at; >http://www.postgresql.org/ftp/win32/ >Allows you to install the DB and / OR the tools including psql >So you can just install the psql command line tool onto your local machine. I can't instal

Re: [SQL] Function description

2008-02-15 Thread Bart Degryse
I can't install applications on my desktop pc ICT won't install that application on my desktop pc... that would require an amout of trust and... >>> Richard Huxton <[EMAIL PROTECTED]> 2008-02-15 12:17 >>> Well, the windows installer comes with the backend database server, psql.exe, pgadmin, manua

Re: [SQL] Function description

2008-02-15 Thread Gavin 'Beau' Baumanis
Hi Bart, Bart Degryse wrote: Richard Huxton <[EMAIL PROTECTED]> 2008-02-15 11:50 >>> >>> To see how e.g. \dC etc work start psql with -E >>> >> I'm sorry, but I don't have commandline access to the database. That would >> require an amount of trust and a level of competence our ICT depart

Re: [SQL] Function description

2008-02-15 Thread Richard Huxton
Bart Degryse wrote: Richard Huxton <[EMAIL PROTECTED]> 2008-02-15 11:50 >>> To see how e.g. \dC etc work start psql with -E I'm sorry, but I don't have commandline access to the database. That would require an amount of trust and a level of competence our ICT department is incapable of. Well,

Re: [SQL] Function description

2008-02-15 Thread Bart Degryse
Richard Huxton <[EMAIL PROTECTED]> 2008-02-15 11:50 >>> >>> To see how e.g. \dC etc work start psql with -E >>> >> I'm sorry, but I don't have commandline access to the database. That would >> require an amount of trust and a level of competence our ICT department is >> incapable of. > >Well,

Re: [SQL] Function description

2008-02-15 Thread Richard Huxton
Bart Degryse wrote: Richard Huxton <[EMAIL PROTECTED]> 2008-02-15 11:15 >>> Dont' forget to cc: the list Bart :-) My mistake, sorry. Normally I only reply to the list and not to the respondent's personal address. Would that be wrong too? Well, some people prefer to reply directly from their

Re: [SQL] Function description

2008-02-15 Thread Bart Degryse
>>> Richard Huxton <[EMAIL PROTECTED]> 2008-02-15 11:15 >>> >Dont' forget to cc: the list Bart :-) My mistake, sorry. Normally I only reply to the list and not to the respondent's personal address. Would that be wrong too? > >Bart Degryse wrote: >> Thanks for that explanation Richard. >> But ho

Re: [SQL] Function description

2008-02-15 Thread Richard Huxton
Dont' forget to cc: the list Bart :-) Bart Degryse wrote: Thanks for that explanation Richard. But how can I know what they repeat without having documentation. I mean, how about functions like eg regexeqjoinsel, regexeqsel, reltimeeq, reltimege. I can imagine they mimic some other functionalit

Re: [SQL] Function description

2008-02-15 Thread Richard Huxton
Bart Degryse wrote: Hi all, I find some 1553 functions in pg_catalog of which only a small part is documented in the manual. Does anyone know where I can find what the others do with maybe an example. There's no other documentation (apart from the source) but most are repetitions and conversi

[SQL] Function description

2008-02-15 Thread Bart Degryse
Hi all, I find some 1553 functions in pg_catalog of which only a small part is documented in the manual. Does anyone know where I can find what the others do with maybe an example.