[GENERAL] Re:

1999-12-30 Thread De Moudt Walter
Peter, Select is the good way, but use LIKE or ~ instead of = for your comparison. It enables you to search on substrings of all kind. SELECT * from my_table where text_field1 like '.' or ...text_field1 ~ '.' This operator has extensive features. You should consult the manual. Some exampl

Re: [GENERAL] Types available

1999-11-10 Thread De Moudt Walter
try the following table : pg_opclass Edouard DESSIOUX wrote: > > Does anyone know which query (with > system tables) could give me all the > available type. > > Txs. > -- > Edouard DESSIOUX > Proverbe chien : > "Si ca se mange pas, > Si ca se baise pas, > Pisse dessus !!" > > *

[GENERAL] money money division, multiplication or conversion

1999-10-31 Thread De Moudt Walter
Hi, i've been searching the operator table for a way to make a money-money division or multiplication. But money/money or money*money doesn't exist. I didn't find any operators for money-to float conversion either. Has any-one got solutions ? Thanks in advance.