FAQ

Search Discussions

30 discussions - 157 posts

  • hi again, Some days ago I asked for help, nobody replied, and after trying to do it in some way, I think aggregate function is the solution to my problem, but I found difficult to understand how it ...
    Raimon FernandezRaimon Fernandez
    May 15, 2007 at 8:56 pm
    May 21, 2007 at 6:40 pm
  • Hello, list. I have a CSV file with two values/row and I would like to import it into a table who has two columns as well. Is there an easy and expedited way to do this with Postgres administration ...
    Oliveiros CristinaOliveiros Cristina
    May 4, 2007 at 11:48 am
    May 6, 2007 at 12:26 pm
  • Parents missing, sorry :-) SELECT a."date",a."theme",a.receiver,COUNT(*) FROM table a INNER JOIN table b ON a."theme" = b."theme" AND a.receiver = b.receiver WHERE (((b."date" - a."date") = 1) OR ...
    Oliveiros CristinaOliveiros Cristina
    May 9, 2007 at 1:46 pm
    May 14, 2007 at 7:49 am
  • Hello again, In my previous databases development, I've been using always a unique longint number for identifying each record. In PostgreSQL I can see that it has the oid, he can do it for you. Also ...
    Raimon FernandezRaimon Fernandez
    May 22, 2007 at 7:30 am
    Jul 6, 2007 at 6:11 am
  • I have a query in which I have joins. something like select a.1, b.2 from a, b where a.3 = b.3; how can I fetch the number of rows returned by this query. normal count(*) doesn't work in this context ...
    Jasbinder Singh BaliJasbinder Singh Bali
    May 31, 2007 at 8:32 am
    Jun 4, 2007 at 4:32 pm
  • Hi, I have a table which looks like this: id info parentid 0 <God 0 1 Adam 0 2 Cain 1 3 Abel 1 4 Seth 1 5 Enosh 4 .... I am looking for a fast and efficient way of finding ALL the descendents of any ...
    Psql-novicePsql-novice
    May 29, 2007 at 5:02 pm
    May 31, 2007 at 11:02 pm
  • Hello, I am new to this list and have been working with PostgreSQL since January. Here is my problem, I hope someone here has some experience or can point me in the right direction. I am writing the ...
    JoshuaJoshua
    May 29, 2007 at 4:12 pm
    May 29, 2007 at 6:06 pm
  • I have a table with a primary key for each row, and a group identification number (groupid) which is not necessarily unique, for each row. As such, I may have 3-5 rows with the same groupid. Anytime ...
    Derrick BettsDerrick Betts
    May 21, 2007 at 6:53 pm
    May 25, 2007 at 1:06 am
  • I thought I saw somewhere a project to use Ocaml as a Procedural Language in Postgresql (so that you can write triggers and stored procedures in Ocaml), but I can't find this project at the moment. ...
    Brian HurtBrian Hurt
    May 14, 2007 at 3:32 pm
    May 15, 2007 at 4:59 pm
  • Dear all, I have the following table: theme | receiver | date ---------+----------------------+------------------------ LIA | +40741775622 | 2007-04-27 00:00:00+00 LIA | +40741775622 | 2007-04-27 ...
    Loredana CurugiuLoredana Curugiu
    May 9, 2007 at 12:07 pm
    May 14, 2007 at 7:57 am
  • Hi, We have a table for an account system: table: compte fields: detail = varchar deure = float haver = float some data: detail: Entrada deure: 0 haver: 5000 detail: Sortida deure: 100 haver: 0 ...
    Raimon FernandezRaimon Fernandez
    May 2, 2007 at 7:51 am
    May 20, 2007 at 6:43 pm
  • Hi All, I'm at temping to migrate a database from a Windows installation (8.1.4) to a Linux installation (8.2.4). I've successfully migrated the schema, but now am running in to difficulties ...
    Neil SaundersNeil Saunders
    May 14, 2007 at 9:23 pm
    May 15, 2007 at 11:54 pm
  • Hello All, Is there a way to determine the percentage of data found in the shared buffer cache when running a query in PostgreSQL 7.4? Or to put it in another way, how do you measure the ...
    Chamara GunaratneChamara Gunaratne
    May 8, 2007 at 7:29 pm
    May 10, 2007 at 5:54 pm
  • Hi all Could not find any reference to this kind of problem in the archives... (or maybe I was not good at searching it... My apologies if so). Trying to update from ubuntu 6.10 to 7.04, something ...
    Pedro A. GalvanPedro A. Galvan
    May 25, 2007 at 2:47 am
    May 25, 2007 at 12:14 pm
  • I've got three tables, <jqz , <zqj , and <abc . I can do a <jqz j RIGHT JOIN zqj z and a <zqj z LEFT JOIN abc a , but is there a way to do a three-way join to get the columns of all three tables? Of ...
    KvnsmnsnKvnsmnsn
    May 22, 2007 at 3:51 pm
    May 22, 2007 at 4:32 pm
  • Hi, I'll have to export from 8.2.4 down to 8.1.8 because our provider runs Debian Sarge and can't offer a newer PG. I tried to pg_dump a plain-text backup an run it through 8.1.8's psql. That failed ...
    AndreasAndreas
    May 20, 2007 at 6:15 pm
    May 20, 2007 at 7:49 pm
  • Hello, in SQLite this query is posible: SELECT acount/1000, SUM(values) FROM acounts GROUP BY acount/1000 this very simple and elegant way to get groups of common acounts, Unfortunately Postgres ...
    Dusan PESLDusan PESL
    May 12, 2007 at 8:33 am
    May 19, 2007 at 5:32 pm
  • Hello, I'm not sure if this is the right list for my question but as I'm novice with Postgres, I think it is ! I currently would like to embed a postgres Notify command inside a trigger function ...
    Christian LeclercChristian Leclerc
    May 4, 2007 at 2:15 pm
    May 4, 2007 at 2:37 pm
  • Hi everyone, This is my first post so and i'm very (very!) new to postgres, I need some help to migrate a clients database from 7.2 to 8.2, on a test machine I already dumped de database and had no ...
    Nuno MonteiroNuno Monteiro
    May 2, 2007 at 10:23 am
    May 2, 2007 at 10:40 am
  • Hello again, It's possible to lock a row outside a transaction in PostgreSQL ? Why I want to do this ? We're using as a Frontend to our future postgreSQL database REALbasic. We open a connection, do ...
    Raimon FernandezRaimon Fernandez
    May 31, 2007 at 10:19 am
    May 31, 2007 at 11:19 am
  • Hello - I'm using PG 8.2. I have the following code snippet: adServerLoadRow domain2_dom%ROWTYPE; attName text; line text; i int; i = 3; attName := split_part(line,E'\t',i); ...
    David MonarchiDavid Monarchi
    May 30, 2007 at 8:28 pm
    May 30, 2007 at 9:51 pm
  • Hi - My apologies in advance if this is in the archives/documentation. I may not have used the correct search terms in trying to find the answer. I've looked at the system tables, particularly ...
    David MonarchiDavid Monarchi
    May 22, 2007 at 8:21 pm
    May 22, 2007 at 11:39 pm
  • Hello, Are there any good/recommended audiobooks and/or podcasts focused on PostgreSQL? I searched, but wasn't coming up with anything. I have some daily drive-time I want to put to better use, and ...
    Gregory ThomsonGregory Thomson
    May 15, 2007 at 6:23 pm
    May 15, 2007 at 6:52 pm
  • Hi, I need to use two phase commit transaction. For connection to other databases I use contribution dblink. But I don't know how to use correctly PREPARE TRANSACTION. I need to rollback transaction ...
    David FleglDavid Flegl
    May 14, 2007 at 8:23 am
    May 14, 2007 at 6:55 pm
  • Is it possible to execute a dynamic query similarly to MS SQL, like so: IF EXISTS(SELECT * FROM Table WHERE Condition) DO SOMETHING I would like to use the PL language in conjunction with conditional ...
    Nicholas BottNicholas Bott
    May 12, 2007 at 12:18 am
    May 12, 2007 at 3:58 am
  • HI, I am trying to learn PostgreSQL for use with Zope. I have Zope 2.9.6, PostgreSQL 8.2 on XP with the Psycopg2 adapter. I had no real problems getting it setup and it is working ok. When I go to ...
    ProgrammerProgrammer
    May 10, 2007 at 7:38 pm
    May 11, 2007 at 2:19 am
  • Hi, If I do the following CREATE TABLE foo AS SELECT * FROM bar and a sequential scan is chosen as the plan (in particular, no ordering required), will the rows be written directly into the new ...
    Brian HerlihyBrian Herlihy
    May 9, 2007 at 5:34 am
    May 9, 2007 at 5:57 am
  • Hey there, I'm interested in getting the content of a SQL query into a file (possibly as an INSERT clause). Is it possible to be done with an SQL statement? Now I think it could be realised as [\copy ...
    Mario PeshevMario Peshev
    May 4, 2007 at 1:45 pm
    May 4, 2007 at 1:56 pm
  • Hi All, I would love some help with this question! I have numerous perl functions in my database. When one of them fails I get the error message "error from Perl function: blah blah", but I can't ...
    SueSue
    May 26, 2007 at 8:28 am
    May 26, 2007 at 8:28 am
  • Dear all, I have the following 3 tables: TABLE 1: themes uid | theme -----+-------- 1 | HOME 2 | BILL 3 | ERROR 4 | ACTION 5 | ANA 6 | LIA 7 | MIA TABLE 2: reminder_services uid | theme_uid | ...
    Loredana CurugiuLoredana Curugiu
    May 10, 2007 at 8:01 am
    May 10, 2007 at 8:01 am
Group Navigation
period‹ prev | May 2007 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions30
posts157
users46
websitepostgresql.org
irc#postgresql

46 users for May 2007

Raimon Fernandez: 25 posts Richard Broersma Jr: 24 posts Tom Lane: 11 posts Loredana Curugiu: 9 posts Oliveiros Cristina: 7 posts Jasbinder Singh Bali: 6 posts Jim Nasby: 6 posts Sean Davis: 5 posts Andrew Jarcho: 3 posts Chamara Gunaratne: 3 posts Derrick Betts: 3 posts Jim Stalewski: 3 posts Oliveiros Cristina: 3 posts Phillip Smith: 3 posts Programmer: 3 posts Andreas: 2 posts Andreas Kretschmer: 2 posts Brian Hurt: 2 posts Burak Seydioglu: 2 posts Christian Leclerc: 2 posts
show more
Archives