[SQL] 7.3 features and enhancements

2002-07-22 Thread mark carew 

Hi All,

Can somebody direct me to a list of the above. Would be nice to know in
advance of its release.

Regards Mark



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [SQL] Problems with version 7.1, could they be fixed in 7.2?

2002-08-28 Thread mark carew 

Hi Ligia,

Are you running VACUUM ANALYSE or is it VACUUM ANALYZE (can never
remember, though reasonably sure that its the former).

Regards Mark Carew
Brisbane Australia



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Hairy question - transpose columns

2002-10-28 Thread mark carew 
Hi Andres,

For mine, I would read the data in using any langauage that I was
familiar with and parse it into
an array or some other form in the required format then create the "copy"
statement for postgresql,
connect and apply.

Regards Mark



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread mark carew 
Hi Hunter,

From my xbase++ program suite, sqlcontext class.
*
cValue := strtran(cValue,['],[\'])
 *
Its called masquarading, simply replace the single quote with back_slash
+ single quote.

Regards
Mark Carew
Brisbane Australia





---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread mark carew 
Woops should have been  masquerading



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] import sql script

2002-12-10 Thread mark carew 
no



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]