Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-17 Thread Kovács Péter
A case in point: When it comes to driving a screw into a material (like wood) in which the screw creates the mating helix itself when first driven in, you might find it helpful to hammer a small portion of the screw into the receiving part, so the screw "gets an initial hold". It is much easie

Re: [GENERAL] Free 1000 Rupee bank note

2006-05-29 Thread Kovács Péter
The legal tender in India, I guess. P. Joe Kramer wrote: What the hell is Rupees? On 5/29/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote: Hi there, Help me by taking this survey. We can both get 1000 Rupees! Click here: http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p

Re: [GENERAL] Are indexes used with LIKE?

2006-01-25 Thread Kovács Péter
Thank you for the answer! Sure, the possiblity of having a separate column for each flag was considered, but a common columnn is preferred -- I do not remember exactly why. (I do not directly make that decision.) I guess the main reason is that adding new columns to the table complicates the u

[GENERAL] Are indexes used with LIKE?

2006-01-23 Thread Kovács Péter
Hi, Are indexes on VARCHAR columns used with the LIKE operator, and if so, how efficiently are they used? I can imagine that using indexes can be easy with the starting literal characters up to the first percent sign such as in: LIKE 'ZOE%QQWE%' But, after the first % sign, things can get

[GENERAL] TX semantics backward compatibility

2005-06-23 Thread Kovács Péter
Hi, We've got a product which supposedly supports the major RDBMSs including PostgreSQL. We tested it so far only with PostgreSQL 7.2 and found no problem. Now, it turned out that it does not work with more recent versions (certainly not with 8.0). The problem is with the kind of code where w