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:
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 to_ascii(
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
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 -> http://www.hobsons.de/pgp/
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 ver
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 cl
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
vern
