On Sep 21, 2007, at 6:16 PM, Stefan Arentz wrote:
Well I'm just toying with an idea. The problem I'm facing is that I
would like clients to only see the tuples that they have created and
own. I guess I'll just skip direct sql access to the db and write some
API on top of it that manages the dat
On 23/09/2007, Matt Magoffin <[EMAIL PROTECTED]> wrote:
> Hello,
>
> My SQL skills are limited and I'm struggling with a query where I want to
> return a single item of an aggregate join. The query looks like this:
>
> select
> (case
> when agg.avg_rating is null then 0.0
> when agg.avg_r
Hello,
My SQL skills are limited and I'm struggling with a query where I want to
return a single item of an aggregate join. The query looks like this:
select
(case
when agg.avg_rating is null then 0.0
when agg.avg_rating < 0.75 then 0.5
when agg.avg_rating < 1.25 then 1.0
when a
Thanks a lot.
Scott Marlowe wrote:
On 9/22/07, John Mulkerin <[EMAIL PROTECTED]> wrote:
I agree its old. I'm working on the upgrade but first need to verify
and then purge some data.
I tried with and without a semicolon
However, with a semicolon results in
Just tried semicolon again..
