es
> 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
_____
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 3
stmas was revoked. So no
software patents in Europe for now. (and the opposition against it seems
to grow!)
--
__
"Nothing is as subjective as reality"
Reinoud van Lee
angesets you'll never want to go back to cvs.
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"
R
nently
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TIP 6: Have you searched o
SQL Anywhere (forgot the firm they bought it from). It took 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 a
-
1
(1 row)
i_hierarchy_id 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 su
igger.
TIA,
Reinoud
--
__
"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
thers :-(
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)
thers :-(
--
__
"Nothing is as subjective as reality"
Reinoud van Leeuwen[EMAIL PROTECTED]
http://www.xs4all.nl/~reinoud
__
---(end of broadcast)---
TI
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.n
> [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 -
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) fr
> 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)
&g
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 r
> 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
> 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
>
>> 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
.
Something like "resultfunction (argument) INTO TABLENAME" or "INSERT
INTO TABLENAME resultfunction(argument)
--
__________
"Nothing is as subjective as reality"
Reinoud van Leeuwen [EMAIL PROTECTED]
http://www.xs4all.nl/~rein
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?
http://www.postgresql.org/search.mpl
in different
continents might not work with 2-phase commit over the network
And we have not even started talking about *managing* replicated
environments. A lot of fail-over scenarios stop planning after the
backup host has take control. But how to get back?
--
___
ostgresql
- install postgresql odbc drivers
- 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"
Rei
eplication server (or different
versions etc).
I do not know how much of this is patented or copyrighted, but the
architecture seems elegant and robust to me. I have done
implementations of bi-directional replication too. It *is* possible
but does require some funky setup and maintenance. (bu
>
> 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
> 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
> a
25 matches
Mail list logo
