for todos... etc.
A wiki for *discussion*? I thought email was for that. A wiki is nice to
work toghether on a document (in some circumstances).
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl
as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
. (and the opposition against it seems
to grow!)
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end
.
Producing an Open Source product does not mean that all tools are Open
Source. Windows isn't and Postgresql is going to support windows.
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 6: Have you searched our list archives
them a few
years to make this product 100% SQL compatible with ASE. This product was
ported to some Unix platforms around that time too.
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
is declared as integer and is not used before this code nor
as a column name anywhere.
Does anyone have a clue what is going wrong? I use Postgresql 7.3.3 on
FreeBSD 4.5.
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
give's me a postgresql that is different from all the
others :-(
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
me a postgresql that is different from all the
others :-(
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
ready for some time now.
What is the status of IPv6 types at this moment?
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
[HACKERS] What executes faster?
Now that I've found the solution for my duplicate key problem,
I'm wondering what executes faster when I have to check for
duplicates.
1. try to update
if no row affected - do the insert
else done
2. do a select
if row not found - do the
Hi,
I have a table that contains almost 8 milion rows. The primary key is a
sequence, so the index should have a good distribution. Why does the
optimizer refuse to use the index for getting the maximum value?
(even after a vacuum analyze of the table)
radius=# explain select max(radiuspk)
Can somebody explain to me:
radius=# explain select count (radiuspk) from radius ;
NOTICE: QUERY PLAN:
Aggregate (cost=12839.79..12839.79 rows=1 width=8)
- Seq Scan on radius (cost=0.00..11843.43 rows=398543 width=8)
EXPLAIN
This query answers me *instantly* after hitting return
On Tue, 28 Aug 2001, Reinoud van Leeuwen wrote:
Can somebody explain to me:
radius=# explain select count (radiuspk) from radius ;
NOTICE: QUERY PLAN:
Aggregate (cost=12839.79..12839.79 rows=1 width=8)
- Seq Scan on radius (cost=0.00..11843.43 rows=398543 width=8
On Tue, 21 Aug 2001, Lamar Owen wrote:
[...]
What who thinks of what has actually become irrelevant. The following
is clear:
o No tool will replace the mailing lists
o The mailing lists are where discussion will be held
o Many/most maintainers have no desire to update
I'm porting some stored procedures from a MSSQL server, and thought I'd
use PL/pgSQL.
The original code is checking the insert with the line:
if (@@Error != 0)
You might want to use something like:
SELECT INTO variable_name *
FROM table
WHERE field = some_value;
IF FOUND THEN
For the result from foo() you must somewhere define attributes
(names).
Where? In CREATE FUNCTION statement? Possible must be:
select name1, name2 from foo() where name1 10;
Yes, optimal would imho also be if the foo() somehow had access to the
where restriction, so it could only
(argument)
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen [EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast
Reinoud van Leeuwen [EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
- generate a database creation script and execute it through the ODBC
connection
- create a report of your database for your documentation :-)
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen [EMAIL PROTECTED]
http://www.xs4all.nl
working on the same
database :-)
just my 2 EURO cts :-)
--
__
Nothing is as subjective as reality
Reinoud van Leeuwen [EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
Hello...
Why does Postgresql order the uppercase letters first?
I have e.g. a table with one row an in this row there are follow
values:
row1
ADC
aa
ABC
With this select-syntax
select * from table order by row1
I become this output
ABC
ADC
aa
but I want this
hi,
i am developing an application using php and postgresql. i do not
know how to capture the return values of functions (stored
procedures) from php.
select myfunction(parameter) ;
---(end of broadcast)---
TIP 5: Have you
24 matches
Mail list logo