Search Discussions

39 discussions - 187 posts

  • Hi, I've been reading several articles on this hotly debated issue and still can't find proper criteria to select one or the other approach for the database I'm currently designing. I'd appreciate ...
    Sep 15, 2008 at 10:15 pm
    Sep 19, 2008 at 6:57 am
  • What is the difference between these two. I know that max() is an aggregate function select model,count(distinct cars) from rc_cars where greatest(baught,returned) < current_date - integer '1' group ...
    Ruben GouveiaRuben Gouveia
    Sep 11, 2008 at 5:33 pm
    Sep 15, 2008 at 8:28 pm
  • Hello All: I have a simple issue. Within my table there is a field DESCRIPTION that I would like to parse and split out into other fields. Within DESCRIPTION there are spaces that separate the data ...
    Kevin DuffyKevin Duffy
    Sep 5, 2008 at 7:56 pm
    Sep 5, 2008 at 9:55 pm
  • Hi, I've been kicking this around today and I can't think of a way to solve my problem in "pure SQL" (i.e. I can only do it with a looping/cursor-type solution and some variables). Given a table with ...
    Steve MidgleySteve Midgley
    Sep 26, 2008 at 5:39 pm
    Sep 30, 2008 at 2:02 pm
  • Does this syntax look correct? Can anyone think of a better way to write this? This function will accept two timestamp parameters and determine the highest of the two? create or replace function ...
    Ruben GouveiaRuben Gouveia
    Sep 9, 2008 at 5:55 pm
    Sep 9, 2008 at 7:24 pm
  • Hi, I just found that two identical queries on two PG 8.2.7 databases with the same data and same encoding, one running on Debian and the other on FreeBSD, returned rows in a different order, even ...
    Sep 19, 2008 at 1:49 am
    Sep 21, 2008 at 2:59 pm
  • No matter how many times i try, i can't seem to get the write amount of ' marks around the date parameters in my v_where declaration. What am i doing wrong here? v_stmt should look like this if done ...
    Ruben GouveiaRuben Gouveia
    Sep 9, 2008 at 11:20 pm
    Sep 10, 2008 at 7:09 pm
  • Hi, I've got five related tables: - person_type: id_person_type integer type_fr text - person: id_person integer ... - person_to_event: id_person - person id_person_type - person_type (e.g: actor, ...
    Louis-David MitterrandLouis-David Mitterrand
    Sep 22, 2008 at 2:40 pm
    Sep 25, 2008 at 8:06 pm
  • Hi, I was looking for a simple solution to this problem. I can't find a way to group on b and n by just collapsing sequential n's (identical n's right next to each other) the sorting condition is the ...
    Nicolas BeuzebocNicolas Beuzeboc
    Sep 22, 2008 at 10:58 pm
    Sep 24, 2008 at 2:25 am
  • Hello Mambers of PGSQL-SQL, I have two tables namely: REGION (region_id, region_name) DISTRICT (dist_id, dist_name, region_id (FK)) I would like to have the CREATE TABLE Command which will create ...
    James KitambaraJames Kitambara
    Sep 17, 2008 at 6:51 am
    Sep 18, 2008 at 12:03 am
  • Good morning, I tried to use prepared query plan to update columns, but it did not update at all. PREPARE pname(varchar) AS UPDATE t1 SET col1 = false WHERE col1 AND col2 = '$1' ; EXECUTE pname( ...
    Emi LuEmi Lu
    Sep 17, 2008 at 7:14 pm
    Sep 17, 2008 at 8:38 pm
  • Will this syntax work: fcn_stats are all in the same schema CREATE OR REPLACE FUNCTION insert_stats(p_date date) RETURNS void AS $$ BEGIN insert into stats ( date, stats1, stats2 ) (select p_date, ...
    Ruben GouveiaRuben Gouveia
    Sep 4, 2008 at 10:16 pm
    Sep 5, 2008 at 4:16 pm
  • Please members of the PGSQL-SQL, I have one problem with the user table. I want to hide the password for the users. The table format is: user ( user_id, user_name, password) But I want the password ...
    James KitambaraJames Kitambara
    Sep 1, 2008 at 7:17 am
    Sep 1, 2008 at 6:36 pm
  • Hey all, I've got a table with a unique constraint across a few fields which I need to regularly import a batch of data into. Is there a way to do it with COPY without getting conflicts on the unique ...
    Glenn GillenGlenn Gillen
    Sep 30, 2008 at 12:16 pm
    Oct 1, 2008 at 4:33 pm
  • Dear Members of I have installed the Apache 2.0.61, PHP 5.2.4 and PostgreSQL 8.1 on my local computer. All three software were successfully tested. I changed “;extension=php_pgsql.dll” to ...
    James KitambaraJames Kitambara
    Sep 26, 2008 at 5:21 am
    Sep 26, 2008 at 6:47 pm
  • Dear friends, I really amazed with this problem and need your help. I run simple query from Query window of PgAdmin3: SELECT * FROM mytable limit 10; and the result are NON UPDATABLE QUERY, while i ...
    Hengky LieHengky Lie
    Sep 16, 2008 at 5:01 am
    Sep 16, 2008 at 9:39 am
  • I tried to do the following and got the following error message: select employee,count(distinct tasks) from job where greatest(max(last_job_date),max(last_position_date)) < 2008-08-28 + integer '1' ...
    Ruben GouveiaRuben Gouveia
    Sep 10, 2008 at 11:11 pm
    Sep 11, 2008 at 12:43 pm
  • Hi, is there an (implicit) way to make a multirow update execute on some rows prior to other rows? It is needed in a case where a trigger is defined on the table as FOR EACH ROW, and it is mandatory ...
    Achilleas MantziosAchilleas Mantzios
    Sep 2, 2008 at 9:58 am
    Sep 3, 2008 at 3:22 pm
  • Hi, can anybody help me, to insert a space between each character in postgresql. for example, ABC output A B C -Dominic
    Nicholas INicholas I
    Sep 17, 2008 at 6:19 am
    Oct 9, 2008 at 6:20 am
  • hi. sorry for the vague syntax used below, but the query is huge so i've tried to present it in simple terms. And sorry if i'm doing obviously stupid things, i have lots of years programming behind ...
    Sep 30, 2008 at 8:51 am
    Sep 30, 2008 at 5:01 pm
  • Hi there, In my DB I have a couple of FK, so the change of referenced columns is a quite complicated. Today, I DISABLE TRIGGER ALL on the tables envolved and then ENABLE TRIGGER ALL to back them. Is ...
    Rafael DomicianoRafael Domiciano
    Sep 12, 2008 at 6:14 pm
    Sep 18, 2008 at 7:48 pm
  • Hi, I'm building a dynamic query as described at http://www.postgresql.org/docs/8.3/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN : EXECUTE 'UPDATE tbl SET ' It works fine, ...
    Raphael BauduinRaphael Bauduin
    Sep 18, 2008 at 9:49 am
    Sep 18, 2008 at 2:06 pm
  • i get the following error when i try and create the following function: Basically, i am trying to have two different dates compared and only the most recent returned to me. This seems pretty straight ...
    Ruben GouveiaRuben Gouveia
    Sep 8, 2008 at 9:40 pm
    Sep 9, 2008 at 2:36 pm
  • Hi, I have installed postgresql-serve using yum hba.conf group and owner were postgres then i changed it to root. when i type psql -U postgres command ( as root user) I get: psql: FATAL: Ident ...
    Sep 8, 2008 at 10:09 am
    Sep 8, 2008 at 12:59 pm
  • HI all, I am facing a problem while taking a back up in windows. It is asking for a password while using pg_dump. Why it is asking for a password ?(it is not asking password in linux) Give some ...
    Sep 19, 2008 at 10:16 am
    Sep 26, 2008 at 10:51 am
  • Hi all, I have some records that have some multiple lines within a single text field. (On top of that, I think I have mixed DOS/UNIX line endings too). I'm looking for two functions which can operate ...
    Mike ToewsMike Toews
    Sep 22, 2008 at 9:56 pm
    Sep 23, 2008 at 3:57 pm
  • I've thrashed at this transform for quite a while and come up empty. The crosstab() functions, and the documented examples, all do something more complex than I need. I can do this after the fact ...
    Karl GrossnerKarl Grossner
    Sep 15, 2008 at 12:06 am
    Sep 16, 2008 at 3:31 pm
  • Good afternoon, I have a question about pg_restore in JAVA and need your help. I planed to do: ================== 1. pg_dump each tables (done successfully) 2. start a java connection auto_commit = ...
    Emi LuEmi Lu
    Sep 10, 2008 at 9:13 pm
    Sep 11, 2008 at 1:48 pm
  • I created a simple function that i want to use another function (in the same schema) that will be used to create a sql statement. I get the following error when i try this: *ERROR: syntax error at or ...
    Ruben GouveiaRuben Gouveia
    Sep 4, 2008 at 8:41 pm
    Sep 4, 2008 at 9:07 pm
  • I can't for the life of me figure out what's wrong with this syntax. I get the following error when i try and create this function. *ERROR: syntax error at or near "$2" at character 15 QUERY: SELECT ...
    Ruben GouveiaRuben Gouveia
    Sep 4, 2008 at 7:36 pm
    Sep 4, 2008 at 7:55 pm
  • Hello, Is it possible to get the min and max from an array of floating point values? The following doesn't return the min of the array values it simply returns the complete array...(??) SELECT ...
    Sep 2, 2008 at 9:17 pm
    Sep 3, 2008 at 12:42 pm
  • Hi. I have a table with a hashcode-field which is a md5-checksum of a file. I updated all null-entries using a rails-script by calling '/sbin/md5 -q' (on FreeBSD). When all null-entries were updated ...
    Claus GuttesenClaus Guttesen
    Sep 2, 2008 at 10:29 pm
    Sep 3, 2008 at 7:20 am
  • Hi. I have two tables, images and duplicates. The images-table is our current table and has approx. 90 mill. entries. I want to weed out duplicate file-entries (based on the md5-checksum of the file ...
    Claus GuttesenClaus Guttesen
    Sep 15, 2008 at 10:05 am
    Sep 15, 2008 at 12:01 pm
  • Hi, Is it possible to select the current UTC time as type timestamp with time zone? select localtimestamp; 2008-09-14 21:55:24.367796 select localtimestamp at time zone 'UTC'; 2008-09-15 ...
    Sep 14, 2008 at 10:15 am
    Sep 14, 2008 at 12:55 pm
  • Hi! I am receiving the following error when trying to execute sql -------------------- Error: ERROR: ExecSubPlan: failed to find placeholder for subplan result (State:HY000, Native Code: 2C) ...
    Kota, PrasoonaKota, Prasoona
    Sep 10, 2008 at 2:14 pm
    Sep 10, 2008 at 4:04 pm
  • Good morning, Is there a way that I can pass "pwd" to pg_dump command please? I tried to pg_dump in java, but do not know how to pass password. Thanks a lot!
    Emi LuEmi Lu
    Sep 9, 2008 at 8:07 pm
    Sep 9, 2008 at 8:16 pm
  • Hello, postgres version: platform windows: server 2008 I check connections using: SELECT pg_stat_get_backend_idset() Now, I take the output and try to get the ip addresses using select ...
    Sofer, YuvalSofer, Yuval
    Sep 8, 2008 at 11:51 am
    Sep 8, 2008 at 12:54 pm
  • Hi, I'm facing an issue, where I build time stamps from a set of strings. In this non working example, I'm looking for a way to cast my strings to the expected format 'timestamp' and timezone... ...
    Marc MaminMarc Mamin
    Sep 22, 2008 at 11:11 am
    Sep 22, 2008 at 11:11 am
  • Apologies if this posts twice... I've run into issues with the listserv lately. I am implementing an autosuggest-style text input for my site, where a user can start typing the name of a thing (call ...
    Christopher MaierChristopher Maier
    Sep 3, 2008 at 1:38 pm
    Sep 3, 2008 at 1:38 pm
Group Navigation
period‹ prev | Sep 2008 | next ›
Group Overview
grouppgsql-sql @

63 users for September 2008

Ruben Gouveia: 17 posts Scott Marlowe: 15 posts Richard Broersma: 11 posts Tom Lane: 10 posts Emi Lu: 6 posts Frank Bax: 6 posts Kevin Duffy: 6 posts Steve Midgley: 6 posts James Kitambara: 5 posts Bart Degryse: 4 posts Fernando Hevia: 4 posts Hengky Lie: 4 posts Louis-David Mitterrand: 4 posts Oliveiros Cristina: 4 posts Raphael Bauduin: 4 posts Richard Huxton: 4 posts Seb: 4 posts Achilleas Mantzios: 3 posts Claus Guttesen: 3 posts Craig Ringer: 3 posts
show more