Re: [GENERAL] How to use as Functional Index to be used as Primary KEY

2004-07-31 Thread Tom Lane
Janning Vygen <[EMAIL PROTECTED]> writes: > So here is my question: How can i define a functional index to be used > with a primary key (using postgreSQL 7.4.3)? You can't. The SQL spec says that primary keys are columns or lists of columns. I don't see any particular difference between a primar

Re: [GENERAL] Correct escaping of untrusted data

2004-07-31 Thread Olivier Guilyardi
Geoff Caplan wrote: Are the standard escaping functions found in the PHP, Tcl etc APIs to Postgres bombproof? Are there any encodings that might slip through and be cast to malicious strings inside Postgres? What about functions like convert(): could they be used to slip something through the escap