Re: [GENERAL] Varchar -> Integer[] conversion

2007-08-25 Thread Joe Conway
Gustavo Tonini wrote: Someone have a function that converts a string literal (a varchar argument) to an integer array? It isn't clear from your question if you want this: select string_to_array('1,2,3'::varchar,',')::int[]; string_to_array - {1,2,3} (1 row) or this: select

[GENERAL] Varchar -> Integer[] conversion

2007-08-25 Thread Gustavo Tonini
Someone have a function that converts a string literal (a varchar argument) to an integer array? Thanks, Gustavo. PS: Please CC to me. I'm not subscribed at list. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings