Re: [SQL] Reverse String in sql or pgplsql

is in plpgsql if possible. Does somebody have this sitting around, I just dont want to reinvent the wheel.  But if need to I will.   Thanks in advance,   Oisin Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com [EMAIL PROTECTED]

[SQL] pg_restore problem -- MORE?!?

somewhere for some more info? I'm having Postgres 8 installed on my production server now and I'll see if I can do a complete dump directly to it and see what happens. Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com [EMAIL PROTECTED]

Re: [SQL] pg_restore problem

mmand to pipe it directly to the server rather than using pg_restore. Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com [EMAIL PROTECTED]

Re: [SQL] pg_restore problem

How exactly can I use this on a mission critical app with flaws like this? How do other people work with this? Do they just not dump the files and restore? On Feb 2, 2005, at 3:24 PM, Tom Lane wrote: Bradley Miller <[EMAIL PROTECTED]> writes: I'm attempting to restore a dump fr

[SQL] pg_restore problem

is is what I'm using to restore the files with: pg_restore -O -x -s -N -d nuvio mac_postgres_2_2_2005_13_24 Any suggestions on how to get around this problem? It's a huge pain so far just to sync my two servers up. Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 91

Re: [SQL] pgdump by schema?

Thanks -- I was looking at a book and it didn't mention the schema dump . . . should have done the man or --help before asking. On Feb 2, 2005, at 9:46 AM, Adam Witney wrote: From: pg_dump --help -n, --schema=SCHEMA dump the named schema only Bradley Miller NUVIO CORPORATION Phone

[SQL] pgdump by schema?

Is there a way to dump everything in a particular schema? Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com [EMAIL PROTECTED]

Re: [SQL] Calendar Function

like to display date in one Month,    e.g : date in feb 2005     calendar  2005-02-01  2005-02-02  2005-02-03  2005-02-04  2005-02-05 ** SNIP ** Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com [EMAIL PROTECTED]

[SQL] URGENT: Using function inside query

above query wold give me the account id of 1.How can I do a query using that function so that it automatically inserts the account_id to show the "rolled up" account id ? Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com [EMAIL PROTECTED]

[SQL] Recursive query to be used in another result ?

: select account_id from roll_account(1186) where hierarchy_type_id = 2 The problem is I want to have that account_id number (1186) to be selected from my main query. (IE: select account_id from account_info) Can anyone offer some solutions to this problem? Bradley Miller NUVIO CORPORATION Phone