Re: [GENERAL] DATE type output does not follow datestyle parameter

2013-07-27 Thread Adrian Klaver
On 07/26/2013 01:24 PM, MauMau wrote: > From: "Adrian Klaver" >> Actually the relevant code seems to be here: >> >> /src/ backend/parser/gram.y >> >> >> CURRENT_DATE >>{ >>/* >> * Transl

Re: [GENERAL] SQL for multimedia retrieval

2013-07-27 Thread John R Pierce
On 7/27/2013 10:28 AM, Olivier Austina wrote: Hi John It doesn't matter where the file is stored. I want to know if I can do some processing like find similar photos or how many a given word appear in the multimedia content ( e.g. an audio or video) using a query language such as SQL. SQL

Re: [GENERAL] SQL for multimedia retrieval

2013-07-27 Thread Olivier Austina
Hi John It doesn't matter where the file is stored. I want to know if I can do some processing like find similar photos or how many a given word appear in the multimedia content ( e.g. an audio or video) using a query language such as SQL. Regards Olivier 2013/7/27 John R Pierce > On 7/27/20

Re: [GENERAL] SQL for multimedia retrieval

2013-07-27 Thread John R Pierce
On 7/27/2013 6:24 AM, Olivier Austina wrote: Can SQL be used to retrieve data from multimedia content such as audio, video, image, full text? it can if the data is stored in the sql database. however for large files like video, I personally would prefer to store it in a file system, and

Re: [GENERAL] Fastest Index/Algorithm to find similar sentences

2013-07-27 Thread Janek Sendrowski
Hi Sergey Konoplev,   If I'm searching for a sentence like "The tiger is the largest cat species" for example.   I can only find the sentences, which include the words "tiger, largest, cat, species", but I also like to have the sentences with only three or even two of these words.   Janek --

Re: [GENERAL] how _not_ to log?

2013-07-27 Thread Marko Kreen
On Fri, Jul 26, 2013 at 2:54 AM, Adrian Klaver wrote: > http://www.postgresql.org/docs/9.2/interactive/sql-alterrole.html > > Caution must be exercised when specifying an unencrypted password > with this command. The password will be transmitted to the server in > cleartext, and it might also be l

[GENERAL] SQL for multimedia retrieval

2013-07-27 Thread Olivier Austina
Hi, Can SQL be used to retrieve data from multimedia content such as audio, video, image, full text? Regards Olivier