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
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 !!"
>
>
*
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.