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
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.
Well, it sounds like you want to look at the EXECUTE command if you're
thinking of writing functions in plpgsql.
However, you don't say how you came to the conclusion that separating
your shipping-table into hundreds of smaller tables was the best design.
Can I ask what testing you did and what the results were?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
