, and until now, didn't really give you enough information to
diagnose many user-related problems.
> But we're mainly constrained on people's time, i.e. money. And AFAICS
> nothing like this is going to happen in this release.
Agreed.
--
Jonah H. Harris, Sr. Software Archite
s not necessarily going to be on our radar
> screen in the foreseeable future.
Agreed.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | [EMAIL PROTECTED]
Edison, NJ 08837 | http://www.ente
On Sun, May 18, 2008 at 4:47 AM, <[EMAIL PROTECTED]> wrote:
> I'm using enterpisedb.
OK. As the Postgres community only supports PostgreSQL, please submit
this and all future EnterpriseDB questions directly to
[EMAIL PROTECTED] or http://forums.enterprisedb.com.
Thanks.
--
J
On Sat, May 17, 2008 at 6:58 PM, <[EMAIL PROTECTED]> wrote:
> statement looks like
> select * from [EMAIL PROTECTED];
Postgres does not support this style of database link syntax. Are you
using Oracle or EnterpriseDB?
--
Jonah H. Harris, Sr. Software Architect | phone:
out that such a wide table is justified.
The few applications I've seen with large tables were an insurance
system, an manufacturing system, and a sensor-recording system (which
was more optimal to store as an attribute-per-instance-of-time than a
separate tuple containing the time, sensor, an
N the result of
both exceptions into a single result set.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | [EMAIL PROTECTED]
Edison, NJ 08837 | http://www.enterprisedb.com/
--
Sent via pgsql-sql mai
On Wed, Mar 19, 2008 at 1:56 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Is there a sql way to compare (in a diff/cmp sense)
> 2 tables? For example,
SELECT * FROM foo
EXCEPT
SELECT * FROM moo;
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corpo
On Feb 2, 2008 7:40 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> Would this be a variation of this item from the TODO:
>
> * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause
Exactly.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
for
Postgres, it didn't support all cases; including the one you're
running into. It's not extremely difficult to extend, but as there
are so few people asking for this functionality, no one has found it
important enough to warrant extension. Perhaps I'll get to it for
8.4.
('ip') <<= ip4r(cidr('cidr'))
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 732.331.1301
499 Thornall Street, 2nd Floor | [EMAIL PROTECTED]
Edison, NJ 08837| http://www.ente
UP BY job;
>
> Amazing! Works like a charm.
> I was envisioning some pretty ugly PL/SQL functions to accomplish this.
>
> Thanks!
No problem.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 732.331.1301
499 Thornall St
ROM emp WHERE job = e.job) AS
varchar2_table_t) FROM emp e GROUP BY job;
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 732.331.1301
499 Thornall Street, 2nd Floor | [EMAIL PROTECTED]
Edison, NJ 08837
unqualified COPY expects all columns
and the syntax I gave you is the only way to limit the columns for
insertion.
You could write your own server-side function to parse, split, and
insert the data, but it would be slower than COPY. Likely, the
easiest thing would be to change your company's
edure doesn't supply it.
BTW, this is done on Weendoze.
Thanks,
Paul.
--
Paul Lambert
Database Administrator
AutoLedgers
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
nes
on the first use.
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 732.331.1301
33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED]
Iselin, New Jersey 08830| http://www.enterprisedb.com/
---(end of bro
y published documentation. In regard to your
other question about performance, see
http://www.varlena.com/GeneralBits/33.html (found with a single Google
search of: tune postgresql performance)
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 7
if you read the manual. As a suggestion, before asking a
question next time, please try and find the answer in the manual
first... it will save you a flame or two from some people on this list
:)
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation
p_num = iter * 2;
INSERT INTO carga
(id, desc_txt)
VALUES (tmp_num, 'My Text for ' || iter || '*2 = ' || tmp_num);
END LOOP;
RETURN;
END;
$$ LANGUAGE plpgsql;
--SELECT for_loop_func(100);
SELECT for_loop_func(10);
--
Jonah H
action yourself with BEGIN.
However, I'm sure each of the driver authors will correct me if I'm wrong :)
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 732.331.1301
33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED]
Iselin
ess you create an explicit transaction with
BEGIN ... (ROLLBACK | COMMIT).
Some of the drivers, however, will create an explicit transaction
behind-the-scenes if you have autocommit mode disabled.
Did that help or was it more confusing?
--
Jonah H. Harris, Software Architect | phone: 732.331.132
that my advice is done with, could you explain why you need to
move to Oracle from PostgreSQL?
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 732.331.1301
33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED]
Iselin, New Jersey
icking it up for 8.3.
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation| fax: 732.331.1301
33 Wood Ave S, 2nd Floor| [EMAIL PROTECTED]
Iselin, New Jersey 08830| http://www.enterprisedb.com/
---(
parsers while C/C++-based databases
use Bison, ANTLR/PCCTS, or a hand-written SQL parser.
A Java database is going to be a lot easier to understand the concepts
of than one in C.
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation| fax: 732.331.130
ish Query for SQL Server or the SQ-HAL project for examples:
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part9/c3261.mspx?mfr=true
http://www.csse.monash.edu.au/hons/projects/2000/Supun.Ruwanpura/
In general, it's easier to write the SQL than to optimize natural
language-b
On 6/29/06, Daniel Caune <[EMAIL PROTECTED]> wrote:
Are you aware of any documentation generator for PL/PgSQL?
I have one somewhere... will have to find it though. I've used the
PL/SQL one before, but I don't think it worked for PL/pgSQL for some
reason.
--
Jonah H.
25 matches
Mail list logo
