[SQL] Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL

On Tue, Jun 22, 2010 at 04:18:48PM +0530, venkat wrote a message of 39 lines which said: > I want to insert and retrieve multilingual (Hindi) into database.is > PostgreSQL supports that ? [Currently, I'm storing arabic texts in a PostgreSQL database.

Re: [SQL] Change size of a field

Hi, Thank you, it works but I loose my foreign keys and the privileges for groups and users. Is there a solution ? Stef -Message d'origine- De : Achilleus Mantzios [mailto:[EMAIL PROTECTED]] Envoye : vendredi 26 juillet 2002 14:50 A : ROUWEZ Stephane Cc : '[EMAIL PROTECTE

[SQL] Problem with my query whithout double-quotes

idu" WHERE "Individu"."NumIndiv"=2 Can someone help me ? Thanks Stephane -- http://www.ecolo.be ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate su

Re: [SQL] Boolean to int

Le jeu 04/07/2002 à 23:32, Arjen van der Meijden a écrit : > How about this hint in the postgresql-manual: > >"Tip: Values of the boolean type cannot be cast directly to other > types (e.g., CAST (boolval AS integer) does not work). This can be > accomplished using the CASE expression: CAS

Re: [SQL] how to use nextval()

Le ven 05/07/2002 à 14:03, [EMAIL PROTECTED] a écrit : > Hello there > > I have an idea how to solve my problem on copy a record to a new one in the > same table. To do so I need the next value for the primary key. > > Using : > > select nextval('pk_auftrag') as nextkey from auftrag; > > I get

[SQL] algoritme

I have a question : I don't know if in a postgres database, it is interisting to create an index for a time stamp champ, Information : data are inerted in a chronological order. thanks Stephane -- Dubreuil Stephane [EMAIL PROTECTED] ---(end of broa

[SQL] Boolean to int

Hi, I'd like to get 1 or 0 from a select on a boolean field. How could I do ? I tried the following rule, which I can't insert : CREATE FUNCTION bool_to_int( boolean ) RETURNS integer AS ' DECLARE my_bool ALIAS FOR $1 ; BEGIN -- Retourn