Re: [sqlite] REGEXP parameter order

On Sun, Jan 23, 2011 at 5:02 PM, Jean-Christophe Deschamps wrote: > 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

[sqlite] REGEXP parameter order

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] Order of UNION query results

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 Gibbs wrote: > >> Could someone please clarify for me if the the resulting order of a UNION >> query will come back with the left