From: | David Blomstrom <david(dot)blomstrom(at)gmail(dot)com> |
---|---|
To: | "Jason O'Donnell" <odonnelljp01(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Hierarchical Query Question (PHP) |
Date: | 2015-10-30 20:47:06 |
Message-ID: | CAA54Z0gjz+bTeu1W0Dc+OwTNvhmCicsn0pvwwfzqMmfy5x8HmQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
No, I get the same T_FUNCTION error.
Someone commented that the function...
create function tax_rank(id integer) returns text as $$
select case id
when 1 then 'Classes'
when 2 then 'Orders'
when 3 then 'Families'
when 4 then 'Genera'
when 5 then 'Species'
end;
$$ language sql;
...should ideally be part of the table schema. Does that mean I need to go
into pgAdmin, open up my table and paste this in somehow?
I wonder if the function is even necessary. My goal is to create a
hierarchical query that displays the number of children, grandchildren,
etc. And, depending on the taxonomic level, it might display the result as
"20 families, 74 genera and 413 species." With MySQL I could probably turn
that into a series of echo values, which I could then display like this:
echo ''.$NumberChildren.' families<br>
'.$NumberGrandchildren.' genera<br>
'.$NumberGreatgrandchildren.' species';
I'm wondering if I should figure out this query or go back to square one
with a simpler query. I've never seen a query with a function before. ;)
Thanks for the tips.
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Colson | 2015-10-30 21:32:22 | Re: Hierarchical Query Question (PHP) |
Previous Message | Jim Nasby | 2015-10-30 20:02:16 | Re: pgxs/config/missing is... missing |