On Nov 22, 2010, at 12:42 PM, Jon Nelson wrote:
> I have an app where I think I'm going to want to use a TEMPORARY TABLE
> like this:
>
> CREATE TEMPORARY TABLE results AS SELECT .;
>
> and then do two things:
>
> 1. I need a select count(1) from that table
> 2. I need to be able to iterat
I have an app where I think I'm going to want to use a TEMPORARY TABLE
like this:
CREATE TEMPORARY TABLE results AS SELECT .;
and then do two things:
1. I need a select count(1) from that table
2. I need to be able to iterate over the rows in that table
The reason I am using a TEMPORARY tab