Re: [sqlite] Order of UNION query results

2011-01-23 Thread Josh Gibbs
Excellent and perfect solution to my problem. Thanks Richard. On 23/01/2011 2:16 a.m., Richard Hipp wrote: On Fri, Jan 21, 2011 at 6:53 PM, Josh Gibbsjgi...@di.co.nz wrote: Could someone please clarify for me if the the resulting order of a UNION query will come back with the left data

[sqlite] REGEXP parameter order

2011-01-23 Thread Jean-Christophe Deschamps
Hi all, Sorry for elementary questions but when implementing a REGEXP function (I'm using PCRE from pcre.org) I need to know in which order the two arguments (target, pattern) will be passed to the function. I also would like to retain the last pattern used in compiled form (connection-wise).

Re: [sqlite] REGEXP parameter order

2011-01-23 Thread Richard Hipp
On Sun, Jan 23, 2011 at 5:02 PM, Jean-Christophe Deschamps j...@q-e-d.orgwrote: Hi all, Sorry for elementary questions but when implementing a REGEXP function (I'm using PCRE from pcre.org) I need to know in which order the two arguments (target, pattern) will be passed to the function. I