creating postgres tables by passing a string to function

Поиск
Список
Период
Сортировка
От Scott cox
Тема creating postgres tables by passing a string to function
Дата
Msg-id BAY109-F333FA3BE29E1744F29825FCD8F0@phx.gbl
обсуждение исходный текст
Ответы Re: creating postgres tables by passing a string to function
Список pgsql-sql
I am storing data separated by month.
How do I perform Inserts and Selects based on something like this.

select * from (select  'shipped' || '0509') AS aShippingTable

The table 'shipped' || '0509' exists.

I am scanning barcode labels which have the '0509' on them and I want to 
move the data
to appropiate monthly tables. '0510' would represent shipped on 2005 
october.

Eventually I want to create, insert, select all based on passing a string 
such as '0509'  to a function.

I am a newbie.
Thanks in advance
-Scott




В списке pgsql-sql по дате отправления:

Предыдущее
От: gurkan@resolution.com
Дата:
Сообщение: regular expression
Следующее
От: Cenk KIZILDAG
Дата:
Сообщение: Getting user created tables from SQL