On Jan 8, 2008 7:36 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> There is no other open source database that can compare with
> PostgreSQL's extensibility, reliability and scalability.
+1000
---(end of broadcast)---
TIP 5: don't forget to increa
On Jan 12, 2008 5:22 PM, Sergei Shelukhin <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I was wondering if I could do something similar to this in Postgres and
> if yes how?
>
> UPDATE table1 SET blah = 1 FROM table1
> INNER JOIN table2 ON table1.id = table2.t1id
UPDATE table1 t1
SET blah = 1
FROM tabl
On Jan 13, 2008 12:05 AM, I said
> It's all in the docs:
> http://www.postgresql.org/docs/8.2/static/sql-update.html
To clarify, you can use the direct form, without using a subselect:
UPDATE table1 t1
SET blah = 1
FROM table2 t2
JOIN table3 t3
ON t2.id = t3.t2id
WHERE t1.id = t2.t1id
Lookup
On Jan 12, 2008 11:26 PM, Sergei Shelukhin <[EMAIL PROTECTED]> wrote:
> Hmmm. What if there's more than one table? Is "from x,y" a viable option?
UPDATE table1 t1
SET blah = 1
FROM (
SELECT t2.t1id
FROM table2 t2
JOIN table3 t3
ON t2.id = t3.t2id
) foobar
WHERE t1.id = foobar.t1id
It's al
On Mon, Oct 11, 2010 at 6:57 PM, David Boreham wrote:
> http://www.xtranormal.com/watch/6995033/
> (warning: may not be sfw).
ROFLMAO!!!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jan 31, 2008 8:49 AM, Enrico Sirola <[EMAIL PROTECTED]> wrote:
> I'd create a "previousTime" column and manage it using a trigger.
> Anyway, it depends on the time-dependancy of the table
> Then you can perform "temporal" in a much easier way.
> You could be interested in taking a look at the fo
On 2/23/08, dvanatta <[EMAIL PROTECTED]> wrote:
> How should this function be written?
Define output parameters in the function and return SETOF RECORD, e.g.:
--- SQL ---
CREATE OR REPLACE FUNCTION
GET_FOO1(BAR INT, OUT BAZ INT, OUT ZAB INT)
RETURNS SETOF RECORD AS
$BODY$
SELECT $1, $1;
$BODY$
LA
On Tue, Feb 26, 2008 at 3:51 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> As discussed earlier I can't use dump/dumpall since my data needs
> persistent tableoids which, however, are not the same after a restore.
What about the workarounds / refactoring tips proposed in previous discussion
On Tue, Mar 18, 2008 at 9:00 AM, Dan Searle <[EMAIL PROTECTED]> wrote:
> I've racked my brain about this but can't think of a simple solution,
> even though this appears to be a simple problem, any suggestions much
> appreciated.
Your fact is split across more than one row.
I recommend that yo
On 3/21/08, Gauthier, Dave <[EMAIL PROTECTED]> wrote:
> I can do it in a formal declaration of a procedure, and then execute the
> procedure. But is there a less formal way?
No. There are no anonymous blocks in PostgreSQL.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Wed, Apr 2, 2008 at 12:36 PM, Alex Solovey <[EMAIL PROTECTED]> wrote:
> ... I have no idea how it could be fixed.
- CREATE INDEX xifoo ON foo(bar_id);
- ANALYZE;
- Retry.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
Also important, consider creating additional indexes based on your
access patterns.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Apr 2, 2008 at 1:20 PM, Alex Solovey <[EMAIL PROTECTED]> wrote:
> In this simple (which means "reduced") test database, yes. But the actual
> table "foo" in production database:
>
> 1. partitioned, with 50+ partitions
> 2. heavily updated (and indexes make it slow)
> 3. has more fields
On Thu, Apr 3, 2008 at 11:50 AM, William Temperley
<[EMAIL PROTECTED]> wrote:
> This works very well, however I'm currently directly concatenating a sql
> query:
>
> select st_collect(the_geom) from tiles where tilename in
> ())
>
> Which leaves my application vulnerable to sql injection.
>
On Thu, Apr 10, 2008 at 10:26 PM, kevin kempter
<[EMAIL PROTECTED]> wrote:
> However I'm stumped [er how to get the number of months from 09/01/2007
> thru 01/01/2007
select extract(month from (age(date '2007-1-1', date '2006-9-1')));
--
Sent via pgsql-general mailing list (pgsql-general@postgr
On Mon, Jun 23, 2008 at 2:45 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
> Actually, the DB I have in mind would certainly be approaching "silly
> territory." I'm looking at a schema with around 10 thousand tables (or
> views).
What kind of app would require such a schema? Just curious...
--
Sent
Here:
http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
Any comments?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Aug 9, 2010 at 1:39 PM, samantha wrote:
> I have been digging into NoSQL of late (...)
Be wary of DBAs Running with Scissors...
http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
On Tue, Jul 22, 2008 at 5:36 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote:
> I've been able to find a couple of packages, but wondering if there is
> a good system out there what will create an ER diagram of an existing
> PostgreSQL DB. Open source would be nice.
PostgreSQL Autodoc: http://www.r
On Fri, Jul 25, 2008 at 8:35 AM, Bruno Lavoie <[EMAIL PROTECTED]> wrote:
> The hesitation here is : how to store the fields & values pairs, in
> FIELDS_VALUES?
Check out contrib/hstore:
http://www.postgresql.org/docs/current/static/hstore.html
--
Sent via pgsql-general mailing list (pgsql-genera
On Sat, Aug 2, 2008 at 9:14 AM, johnf <[EMAIL PROTECTED]> wrote:
> I wonder if he talking about pgadmin3? It's on the menu.
Only J.M. knows for sure...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
On Tue, Aug 26, 2008 at 2:41 AM, Ivan Price <[EMAIL PROTECTED]> wrote:
> If anyone knows of such a thing i'd greatly appreciate some advice..
Gedafe - http://isg.ee.ethz.ch/tools/gedafe/index.en.html
DaDaBIK - http://www.dadabik.org/
Good luck.
--
Sent via pgsql-general mailing list (pgsql-gen
On Wed, Sep 17, 2008 at 9:43 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> The subjects says it all.
A couple of links that may be of use:
http://pooteeweet.org/files/phpworks06/explaining_explain.pdf
http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf
Good l
On Sun, Oct 12, 2008 at 8:10 PM, Ben Chobot <[EMAIL PROTECTED]> wrote:
> On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
> > could you provide a brief explanation of EAV ?
>
> (...) in an EAV model you would do something like:
> create table eav
> (
> kind text primary key,
> attr text,
> value t
On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
> sorry I get nothing :(
Of course not. None of the dates you gave in the example overlap.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
On Wed, Nov 26, 2008 at 3:36 PM, Karina Guardado <[EMAIL PROTECTED]> wrote:
> I have a problem I have created a database with encoding SQL_ASCII and when
> I insert the data using a terminal in linux and insert the data for example
> Insert into mytable values(1,'Eléctrico'); it works fine but if I
http://www.dbms2.com/2011/11/23/hope-for-a-new-postgresql-era/
Some of the points mentioned:
- MySQL is narrowing the gap, but PostgreSQL is still ahead of MySQL
in some ways. (Database extensibility if nothing else.)
- Neither EnterpriseDB (which now calls itself “The enterprise
PostgreSQL
c
Quote:
==
This thread
http://postgresql.1045698.n5.nabble.com/Multithread-Query-Planner-td5143643.html
was mentioned in a performance sub-group posting. Give it a read.
Back? It means, so far as I can see, that PG is toast. It
On Jan 26, 4:52 pm, Rodrigo E. De León Plicet
wrote:
> Quote:
>
> ==
>
> This thread
>
> http://postgresql.1045698.n5.nabble.com/Multithread-Query-Planner-td5...
>
> was mentioned in a performance s
On Wed, Jan 21, 2009 at 5:44 PM, Keaton Adams wrote:
> Is there a way to do this in a single SQL statement in PostgreSQL 8.1?
SELECT
d.policyNumber
, d.CompanyName
, d.Address
, p.AllPolicyNumbersIncluded
FROM PolicyPrint p
INNER JOIN PolicyDetails d
ON (
p.cicPolicyNumber =
2009/2/20 Angelo Astorga :
> Tenia RH enterprise 3.0 con postgresql 7.4.3 y PHP 4.3.2, migre todo a RH
> enterprise 5.3 con postgresql 8.1.11 y PHP 5.1.6, migre la BD y pude
> montarla, pero, no tengo acceso a la BD desde apache... algun ayudita al
> respecto !!!
Demasiado impreciso; adicionalment
On Fri, May 22, 2009 at 10:38 PM, Scott Marlowe wrote:
> On Fri, May 22, 2009 at 4:10 PM, Benjamin Smith
> wrote:
>>
>> Is there a better way?
>
> Yeah, natural keys.
+1.
Also, what Ben described reeks of EAV.
Ben, please read:
http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-ta
32 matches
Mail list logo
