subject:"\[SQL\] creating postgres tables by passing a string to function"

Re: [SQL] creating postgres tables by passing a string to function

2005-10-05 Thread Richard Huxton

Scott cox wrote: 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

[SQL] creating postgres tables by passing a string to function

2005-10-04 Thread Scott cox

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