Andrew Sullivan wrote:
> This is probably better on -performance, and is certainly a FAQ.
> But. . .
>
> On Wed, Feb 23, 2005 at 03:01:52PM +0100, Thomas Braad Toft wrote:
> >
> > Table device contains 5285 rows, tmeevent contains 834912 rows.
>
Sorry for being redundant (I asked this a while back).
I was looking for in days before and used date math
Date1::date - date2::date returned the days which was fine for my original
question.
I did get a reply mentioning the age function and he mentioned I could get
minutes etc.
I looked up age in
Richard Huxton writes:
> Steve - DND wrote:
>> This doesn't seem to be quite what I'm looking for.
> Well, if psql vars, prepare or functions don't meet your needs, I'm not
> sure we've got anything that will.
ecpg is another possible answer.
> Have you got a specific example where these don't
Couldnt you do a select * from t1 where not in uniquevar (select uniquevar
from t2)?
Or do a join and select on a value in t2 being null.
Joel Fradkin
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://a
Steve - DND wrote:
Michael's given you one option - another to look at is PREPARE/EXECUTE
PREPARE my_query(int4) AS INSERT INTO foo VALUES ($1);
EXECUTE my_query(1);
EXECUTE my_query(7);
...
This doesn't seem to be quite what I'm looking for. PREPARE according to the
docs is for a one line stateme
I have two tables
that should contain the same number or records. Both tables use the same
2 foreign keys as their primary keys.
I did a count on the
number of records in both and found one table has 500 records less than the
first table so I need to know which records are not in the secon
Steve - DND wrote:
I don't know about pgAdmin, but in psql you can use \set:
\set id 1
SELECT * FROM foo WHERE id = :id;
\set name '\'Some Name\''
SELECT * FROM foo WHERE name = :name;
Whenever I try the above I get an error at the backslash. Do I need to
create a different language for this? Righ
>
> I don't know about pgAdmin, but in psql you can use \set:
>
> \set id 1
> SELECT * FROM foo WHERE id = :id;
>
> \set name '\'Some Name\''
> SELECT * FROM foo WHERE name = :name;
>
Whenever I try the above I get an error at the backslash. Do I need to
create a different language for this? Right
On Thu, Feb 24, 2005 at 10:04:50AM -0700, Steve - DND wrote:
> > \set name '\'Some Name\''
> > SELECT * FROM foo WHERE name = :name;
>
> Whenever I try the above I get an error at the backslash. Do I need to
> create a different language for this? Right now I only have plpgsql
> available.
Did y
> Michael's given you one option - another to look at is PREPARE/EXECUTE
> PREPARE my_query(int4) AS INSERT INTO foo VALUES ($1);
> EXECUTE my_query(1);
> EXECUTE my_query(7);
> ...
This doesn't seem to be quite what I'm looking for. PREPARE according to the
docs is for a one line statement. I'm l
Unsuscribe
__
Renovamos el Correo Yahoo!: ¡250 MB GRATIS!
Nuevos servicios, más seguridad
http://correo.yahoo.es
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go t
Joel Fradkin wrote:
Thanks.
I guess I could add that logic, but this is a one time process going to run
the night we go live on postgres.
With .net it took like 2 hours to do the whole shebang, so I am happy.
Fair enough. I tend to produce a text-file and use COPY for bulk
transfers, but that's ju
I had a good install, but I did not
install 7.4 when I installed redhat.
It asked for the cd’s a couple times
when I loaded the RPMS 8.0.1
I also did not use any fire wall or
security (it is in a secure environment).
Joel Fradkin
__
Thanks.
I guess I could add that logic, but this is a one time process going to run
the night we go live on postgres.
With .net it took like 2 hours to do the whole shebang, so I am happy.
But I was curious as we will be using odbc for our asp (aprx 90% of our
app).
I could test wrapping the .ne
Richard Huxton writes:
> Search the mailing-list archives for "custom aggregate concat" and
> you'll quickly find an example of how to write your own custom aggregate
> (like SUM()).
> Warning - I don't think you can guarantee the order of elements in the
> aggregated sectors.
In recent PG ve
Hi,
Could someone please give a hint on how to query the following neatly ?
Get news from a news table that belong to a particular account, get segment
name from segments table for each news item and read count from read history
table that gets a news_id and timestamp insert every time the news
Hi all, Ive just installed the latest version of Postgres 8 on a RedHat 9 server. The problem im having is than when I try to login to the database i.e. 'psql -U postgres template1' im getting the following message:
psql: relocation error: psql: undefined symbol: PQsetErrorVerbosity
Upon rea
Kai Hessing wrote:
Another question: Which software are you using to visualize your
database-structur. We're doing it with Quark, but are not very happy
with this.
DbVisualizer (free version)
http://www.minq.se/products/dbvis/index.html
--
Regards/Gruß,
Tarlika Elisabeth Schmitz
---
Joel Fradkin wrote:
No I did not do it in on transaction (although in .net I never started or
commited a transaction.
All inserts/updates/etc take place within a transaction with PostgreSQL.
Some client libraries autocommit for you - you'll need to read the
documentation.
ODBC :
myCommand.Comman
Hi,
Because of the actual limitations of Postgresql inheritance mecanism
regarding constraints, I'm not willing to use it in my project, although
it's exactly the kind of idea I need:
In an order and manufacturing management system, several different items
can be ordered, each of them with specif
No I did not do it in on transaction (although in .net I never started or
commited a transaction.
ODBC :
myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted)
' Assign transaction object for a pending local transaction
myCommand.Transaction = myTrans
'example of insert
'myCommand
If you mean literally visualizing the ERD, you can look at
SQL::Translator (on cpan) which can draw fairly complex ERDs and output
as graphics (I forget the supported formats)
Sean
On Feb 24, 2005, at 3:17 AM, Richard Huxton wrote:
Kai Hessing wrote:
Another question: Which software are you
Hello Keith,
Thank you for your help.
Keith Worthington wrote:
T E Schmitz wrote:
Tables:
TRANSAKTION
---
KIND ('R' or 'S' for refund or sale)
TRANSAKTION_PK
PAYMENT_METHOD (cheque, cash, CC)
ITEM
TRANSAKTION_FK
ITEM_PK
RETAIL_PRICE
DISCOUNT
Desired result set:
PAYMENT_METHOD | categor
In pgadmins SQL-window SQL is the 'language' of choice. Or it is rather the
only language. Thus if you intend to program plTk or PL/pgSQL, there's no
way around defining a function.
(At first you have to define a new language in your schema)
C:\> -Original Message-
C:\> From: Steve - DND
Kai Hessing wrote:
The normal clause would look like:
SELECT c.companyname, s.sectorname FROM company c, sector s,
company_sector cs WHERE cs.cid = c.cid AND cs.sid = s.sid ORDER BY
c.companyname;
c.companyname | ??? (sectors)
---+
company1 | secto
Steve - DND wrote:
I really have to be missing something here and this probably a *really* noob
question. I don't have a problem running little junk queries in the pgAdmin
query window(SELECT blah FROM blah, INSERT INTO blah, etc...), but I can't
figure out how to run queries with variables outside
Kai Hessing wrote:
Another question: Which software are you using to visualize your
database-structur. We're doing it with Quark, but are not very happy
with this.
Well, AutoDoc can generate HTML/Dia/other outputs
http://www.rbt.ca/autodoc/index.html
Might be worth checking the (freely available)
mauro wrote:
Hi, In previous version di Postgres (7.2) I used this table:
CREATE TABLE tablename (id serial, field int1, field2 text);
Now this query work:
UPDATE tablename SET field1=''; (NOTE: implicit conversion to 0)
UPDATE tablename SET field2='';
(this cause of simple code-generation query -
mauro wrote:
Hi, I understand this is an super-older thread!! note: i like
postgres and not mysql!
Hi Mauro! Whether you like it or hate it, you're in the right place to
ask questions about it.
I'm a Postgres server user: I've postgres 7.2 and 8.0 in many servers
and I've tested performance Postgr
29 matches
Mail list logo
