Can
please some of the administrators remove that member or
what-o-else
-Original Message-From: AntiSpam UOL
[mailto:[EMAIL PROTECTED]Sent: Dienstag, 07. Juni 2005
11:22To: KÖPFERL RobertSubject: RE: Re: [SQL] SQL
equivalent to nested loop
ANTISPAM UOL »
To me it seems that the definer of this table missed the concept index ...
or the concept database
One usually looks up data using a key, but if the whole row is the key, what
data shall be looked up.
So short story long: Remove data from your index. The data column seems
like the data to be look
Thanks.
Since I was just interested in this special case (while the general wasn't
interesting, either) this helped me. Also psql -E is a nice new feature to
me.
|-Original Message-
|From: Michael Fuhr [mailto:[EMAIL PROTECTED]
|Sent: Montag, 30. Mai 2005 16:09
|To: KÖPFERL Robert
|Cc: pgs
Hmmm, you're right.
Is there any way to do a
explain select * from id_val_tbl where false
while explain doesn't tell SEQ_SCAN?
I have to admit that I didn't performance tested this. I just saw explain
writing SEQ_SCAN.
|-Original Message-
|From: Tom Lane [mailto:[EMAIL PROTECTED]
|Sent:
If you are interested in performance things, you may use the EXPLAIN
command:
explain select * from "GetLanguages"() where "Id" > 44
vs.
explain select * from "Languages" where "Id">44;
However the explain stops at the point a function is invoked.
This may mean that (as you asked) a select ove
|-Original Message-
|From: Goulet, Dick [mailto:[EMAIL PROTECTED]
|Sent: Montag, 07. März 2005 16:33
|To: John DeSoi; Stef
|Cc: pgsql-ADMIN@postgresql.org; pgsql-sql@postgresql.org
|Subject: Re: [SQL] [ADMIN] Postgres schema comparison.
|
|
| My favorite for this task is WinSql available f
PL/pgSQL is not part of template1 = if you create a new database.
Thus you can use for functions just pure SQL or C. To get pgSQL I did that:
CREATE OR REPLACE FUNCTION plpgsql_call_handler()
RETURNS language_handler AS
'$libdir/plpgsql', 'plpgsql_call_handler'
LANGUAGE 'c' VOLATILE;
CREATE
Thanks.
I managed it via a trigger.
> -Original Message-
> From: Michael Fuhr [mailto:[EMAIL PROTECTED]
> Sent: Sonntag, 13. Februar 2005 02:57
> To: KÖPFERL Robert
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Constraint doesn't see a currently insertet record
>
>
> On Fri, Feb
This
seems more less rpm-related.
However: Already tried to uninstall the old
packages?
# man
rpm
-Original Message-From: Joel Fradkin
[mailto:[EMAIL PROTECTED]Sent: Samstag, 05. Februar 2005
23:36To: pgsql-sql@postgresql.orgSubject: [SQL]
postgres8 install on fedora core
That's bad.
Is there really no ohter way?
So it takes TWO termoral tables. Or even more?
And it can't be just sql because theres more around that statement.
> -Original Message-
> From: Sean Davis [mailto:[EMAIL PROTECTED]
> Sent: Donnerstag, 27. Jänner 2005 14:57
> To: KÖPFERL Robert
> C
It's ... hm
I have the feeling that even complicated and boxed queries are faster or can
be optimized by the planer than any PLpgsql. Isn't there a motule that has
to be invoked?
I'm capable to learn.
> -Original Message-
> From: Michael Fuhr [mailto:[EMAIL PROTECTED]
> Sent: Mittwoch, 19
As so often, I would suggest regular languages to accomplish most of the
work that comes up.
Use for example ours all friend 'sed' to edit a big sql-dump.
you can for example simply replace isnull(X) by X is null.
RegEx will possibly not reach for all posibilities but the're very good for
the fir
Thanks, but that was not what I was looking for.
Seems that I forgot to mention that this function is intended to be written
in SQL, not in PL/SQL. For the second one I already picked it off the
fascinating* doc (as Keith did) that GET DIAGONSTIC is the right thing.
So what variable/function is t
Did you try to
explicitly give the type for the literal?
e.g.
''::varchar
-Original Message-From:
Yudie [mailto:[EMAIL PROTECTED]Sent: Montag, 17. Jänner 2005
19:44To: pgsql-sql@postgresql.orgSubject: [SQL] query
configuration for validate empty quote to zero
We just changed
Yo can do s.t. similar, if the order in which you select the columns
corresponds to the order your type is defined.
So you'd gonna use: select intcol, textcol from table;
> -Original Message-
> From: Din Adrian [mailto:[EMAIL PROTECTED]
> Sent: Montag, 17. Jänner 2005 13:31
> To: pgsql-sql
I think don't really unterstand your intend.
However there exists a type text in SQL and Postgres which is a text of
unspecified length and used like a SQL-String. Thus quoted with '
So when you earlier were able to gain the content of that field. It should
be no problem to quote it.
> -Origi
Thank you all for your thinkings.
It seems like there's no realy good way to solve that kind of problem (maybe
used IDs). Thus I made a design change happen. We went to 64-Bit which
should solve the problem until the computers already fellt into dust.
> -Original Message-
> From: PFC [m
> -Original Message-
> From: Andrew Sullivan [mailto:[EMAIL PROTECTED]
> Sent: Donnerstag, 13. Jänner 2005 20:49
> To: 'pgsql-sql@postgresql.org'
> Subject: Re: [SQL] Column with recycled sequence value
>
...
> > used 2^32 will be reached soon and then? There are far less
> than 4G-reco
The first seems like an appropriate solution. Fireing a trigger-function
that returns null.
If I however try to implement a function getnull in sql I fail. Defining the
trigger requests a function of type trigger while definition of a function
forbids using trigger as return type. So RTFM - there's
Thank you for this rather detailed example.
I already learned something and omitted a fault. There should be enogh to
implement such a Queue. :-)
> -Original Message-
> From: Andrew Hammond [mailto:[EMAIL PROTECTED]
> Sent: Mittwoch, 12. Jänner 2005 17:19
> To: KÖPFERL Robert
> Cc: 'pgsq
Also I thought of an UNIQUE constraint on a column with =const constraint.
But
It's for global configuration data that exists only once.
Making a key value thing was to weak typed for my taste.
> -Original Message-
> From: Dmitri Bichko [mailto:[EMAIL PROTECTED]
> Sent: Dienstag, 11
21 matches
Mail list logo
