Hi,
and thanks for the answer ;) (*upps* just noticed, that I sent the
answer accidently direct to poster^^ *sorry*)
Michael Fuhr schrieb:
I'll pick a nit and point out that the above isn't a valid query:
test= SELECT xyz, abc FROM (SELECT * FROM tablex WHERE status -1);
ERROR: subquery
This is the question i'm telling myself. It is because we don't really
delete table entries, just setting a status field to '-1'. So a valid
select would look like: SELECT xyz, abc FROM (SELECT * FROM tablex WHERE
status -1);
It would be much nicer to have to write something like: SELECT xyz, abc
I have a little problem in PostgreSQL 7.39 (and previous). Our database
is in 'SQL_ASCII'-Format. When doing SQL-Selects all special Characters
(e.g. äöüß, etc...) are ASCII encoded (sure they are). Is there any
function to change the encoding to - let's say - LATIN1 (reverse
function for
Hi,
Tom Lane schrieb:
[ experiments... ] This works reliably in 7.4 and up. Before that,
the optimizer didn't make the connection between the sort ordering of
the inner query and that needed by the outer, so it would repeat the
sort step using only key1 and very possibly destroy the key2
Richard Huxton schrieb:
Search the mailing-list archives for custom aggregate concat and
you'll quickly find an example of how to write your own custom aggregate
(like SUM()).
Warning - I don't think you can guarantee the order of elements in the
aggregated sectors.
Thank you very much.
Sean Davis schrieb:
If you mean literally visualizing the ERD, you can look at
SQL::Translator (on cpan) which can draw fairly complex ERDs and output
as graphics (I forget the supported formats)
I'll have a look at it. Thank you both!
--
GnuPG-PublicKey -
Another question: Which software are you using to visualize your
database-structur. We're doing it with Quark, but are not very happy
with this.
Thanks
Kai...
--
GnuPG-PublicKey - http://www.hobsons.de/pgp/kai_hessing.asc
Viele, die die schaendlichsten Handlungen begehen, fuehren hoechst
Hi Folks,
I hope to have found the right group for my question. I have difficult
sql-task. I try to describe it simple:
We have a table 'company' with a cid and a table 'sector' with a sid.
They are connected m:n via a third table 'company_sector' which contians
csid, cid and sid.
The normal
