[GENERAL] Sanity check...

2006-12-06 Thread Eric Andrews
I have a signifigant number of tables that each have a name_date naming scheme. I want to write a function that takes a start and end date as arguments, and optionally a name, and returns a view of all tables joined together by the name of the supplied name, er - if supplied. is there a better way

Re: [GENERAL] proper use of array datatype

2006-08-02 Thread Eric Andrews
On 8/1/06, Reece Hart <[EMAIL PROTECTED]> wrote: Eric Andrews wrote: > I am not much of a schema designer and have a general questoin about > the proper use of the array datatype. In my example, I have > destinations, and destinations can have multiple boxes, and insid

Re: [GENERAL] proper use of array datatype

2006-08-01 Thread Eric Andrews
On 8/1/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote: On 8/1/06, Eric Andrews <[EMAIL PROTECTED]> wrote: > ... and inside > those boxes are a set of contents. what I want to do is search and > basically "mine" data from the content sets. do I use an array &g

[GENERAL] proper use of array datatype

2006-08-01 Thread Eric Andrews
hello all, I am not much of a schema designer and have a general questoin about the proper use of the array datatype. In my example, I have destinations, and destinations can have multiple boxes, and inside those boxes are a set of contents. what I want to do is search and basically "mine" data f