FAQ

PostgreSQL > pgsql-sql

Search Discussions

11,964 discussions - 44,015 posts

  • Perhaps this is just what you are looking for, right? Recover Data from Android Phone <http://www.ipubsoft.com/recovery/recover-deleted-data-from-android-phone.html ...
    WalerinaWalerina
    Aug 30, 2013 at 8:55 am
    Aug 30, 2013 at 8:55 am
  • Does anyone know if there are any CTAGS extensions or variants that support PL/pgSQL ? I use exuberant-ctags which does not support it, and a web search does not return anything promising. (I sent ...
    Charles SheridanCharles Sheridan
    Aug 28, 2013 at 3:08 pm
    Aug 29, 2013 at 2:17 pm
  • Hello. I want to run an automatic archiving SQL script, that looks at a meta-table containing data about the tables to be archived. Basically, suppose I have this data in the meta-table: table_name ...
    Herouth MaozHerouth Maoz
    Aug 28, 2013 at 10:07 am
    Aug 28, 2013 at 10:45 am
  • Hello When I run : SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR), '-', CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii))) FROM lab_tests_reference_values ltrv1 GROUP BY ...
    Victor SterpuVictor Sterpu
    Aug 25, 2013 at 12:15 pm
    Aug 25, 2013 at 1:19 pm
  • I have a table containing tasks completed in a game I'm playing. The game includes an extra BINGO Challenge where each cell of standard BINGO card contains a particular task to be completed. The goal ...
    F BaxF Bax
    Aug 3, 2013 at 1:26 pm
    Aug 5, 2013 at 4:01 am
  • I have a table with fields as follows: * sag_id * sag_header * sag_comments * sag_date * sag_section_id (**) * sag_artist_id (**) * sag_author_id (**) * sag_producer_id (**) As you can see, fields ...
    JORGE MALDONADOJORGE MALDONADO
    Jul 26, 2013 at 11:10 pm
    Jul 27, 2013 at 12:31 am
  • I guess I am understanding that it is possible to set a unique index or a unique constraint in a table, but I cannot fully understand the difference, even though I have Google some articles about ...
    JORGE MALDONADOJORGE MALDONADO
    Jul 26, 2013 at 9:44 pm
    Jul 27, 2013 at 7:13 am
  • Hi folks, I need help please. I have a table of trip section details which includes a trip ID, start time as an offset, and a duration for that section. I need to extract the full trip duration by ...
    Gary StainburnGary Stainburn
    Jul 25, 2013 at 5:45 pm
    Jul 26, 2013 at 8:18 am
  • I have 2 tables, a parent (tbl_persons) and a child (tbl_languages_per_person) as follows (a language table is also involved): ------------------ tbl_persons ------------------ * per_id * per_name * ...
    JORGE MALDONADOJORGE MALDONADO
    Jul 23, 2013 at 9:44 pm
    Jul 24, 2013 at 10:12 am
  • Postgres 9.2.4. I have two columns, approved and comments. Approved is a boolean with no default value and comments is a character varying (255) and nullable. I am trying to create a constraint that ...
    Ldrlj1Ldrlj1
    Jul 22, 2013 at 2:05 pm
    Jul 22, 2013 at 2:53 pm
  • http://faribradytattoo.dk/hhmqna/sninwzk.umbobbqmel Mag Gam 7/21/2013 7:22:12 AM
    Mag GamMag Gam
    Jul 21, 2013 at 6:22 am
    Jul 21, 2013 at 6:22 am
  • Hi I would like to list the definition of all user tables by only one command. Is there a way to *not* show pg_catalog tables when using "\d ." in PostgreSQL 9.1.9? Thanks.
    Carla GoncalvesCarla Goncalves
    Jul 17, 2013 at 3:29 pm
    Jul 24, 2013 at 10:00 am
  • Dear list, This might be a postgis-specific question, but I could not get access to the postgis mailing list so I will have a try here as my problem might be related to SQL: I need to update a column ...
    Stefan SyllaStefan Sylla
    Jul 16, 2013 at 2:53 am
    Jul 17, 2013 at 9:58 am
  • Hi Guys We are migrating to Postgres. In the current system, we use datediff() function to get the difference between two dates, e.g. datediff (month, cast('2013-01-01' as timestamp), ...
    Huan RuanHuan Ruan
    Jul 11, 2013 at 5:17 am
    Jul 11, 2013 at 6:19 am
  • If I have two tables, T1 and T2, such that both have the same primary key of "user_id". What is the SQL I would use to delete all rows from T1 that are not in T2? This is one way to write the SQL but ...
    Campbell, LanceCampbell, Lance
    Jul 9, 2013 at 7:25 pm
    Jul 14, 2013 at 7:25 am
  • I'm writing a system with havy use of composite types. I have a doubt. I'm writing all in functions with language plpgsql. When I read a field from a composite type I must write something like this ...
    Luca VerniniLuca Vernini
    Jul 8, 2013 at 1:11 pm
    Jul 8, 2013 at 11:25 pm
  • Hi, I need to show a moving statistic of states of objects for every month since beginning of 2013. There are tables like objects ( id integer, name text ); state ( id integer, state text ); 10=A, ...
    AndreasAndreas
    Jul 8, 2013 at 12:17 pm
    Jul 24, 2013 at 11:27 am
  • Hello, All unquoted identifiers are assumed by PostgreSQL to be lower case by default. This means - SELECT MY_COLUMN FROM my_table - SELECT my_column FROM my_table - SELECT my_column as MY_COLUMN ...
    Dev KumkarDev Kumkar
    Jul 3, 2013 at 9:12 am
    Jul 3, 2013 at 11:29 pm
  • Hi all I just want to confirm something regarding UNNEST function used with arrays. I cannot see that it is specifically mentioned in the documentation , but maybe because it is obvious. Is the order ...
    GmbGmb
    Jun 20, 2013 at 10:41 am
    Jun 20, 2013 at 1:34 pm
  • Working on Ubuntu 13.04 64bit (raring) I red, that Pitti-PPA will be discontinued in the future, so we should make the switch to apt.postgresql.org. But trying to "aptitude install postgresql-9.3" ...
    RawiRawi
    Jun 18, 2013 at 10:12 am
    Jun 18, 2013 at 11:31 am
  • Is it valid to specify a SELECT statement as part of a JOIN clause? For example: SELECT table1.f1, table1.f2 FROM table1 INNER JOIN (SELECT table2.f1, table2.f2 FROM table2) table_aux ON table1.f1 = ...
    JORGE MALDONADOJORGE MALDONADO
    Jun 13, 2013 at 10:40 pm
    Jun 14, 2013 at 7:16 am
  • Hi I tested the following: CREATE TABLE t1 ( id serial NOT NULL, a character varying(125), a_tsvector tsvector, CONSTRAINT t1_pkey PRIMARY KEY (id) ); INSERT INTO t1 (a, a_tsvector) VALUES ...
    RawiRawi
    Jun 13, 2013 at 11:39 am
    Jun 21, 2013 at 9:31 am
  • I need to insert records into a table where one value is fixed and 2 values come from a SELECT query, something like the following example: INSERT INTO table1 fld1, fld2, fl3 VALUES value1, (SELECT ...
    JORGE MALDONADOJORGE MALDONADO
    Jun 7, 2013 at 1:59 pm
    Jun 7, 2013 at 2:25 pm
  • I have an update query that I'm not sure if I am taking a good approach or a naive one. It works but seems ugly. I have a table named "contacts". Contacts have a user_id and an owner_id. There is ...
    Robert DiFalcoRobert DiFalco
    Jun 2, 2013 at 8:39 pm
    Jun 2, 2013 at 8:39 pm
  • Sorry, I wasn't sure what list I should be sending this question to... I have a multi-tenant-like application. We have a fields tree that we call a template, with something like this: fields(id, ...
    Rodrigo Rosenfeld RosasRodrigo Rosenfeld Rosas
    May 29, 2013 at 1:58 pm
    May 29, 2013 at 4:14 pm
  • I have a query like this: SELECT lpt_titulo AS tmt_titulo, tmd_nombre AS tmt_nombre, tmd_album AS tmt_album SUM(lpt_puntos) AS tmt_puntos, lpt_fuente AS tmt_fuente FROM listas_pre_titulos, ...
    JORGE MALDONADOJORGE MALDONADO
    May 25, 2013 at 5:17 pm
    May 25, 2013 at 5:52 pm
  • Dear all, I am trying to translate a code written in php to C++. So, I am now using lipq in order to access my postgresql database from C++. As performance is an important feature, I am using ...
    Brice AndréBrice André
    May 25, 2013 at 11:07 am
    May 27, 2013 at 7:06 am
  • Here is a boiled down example of a scenario which I am having a bit of difficulty solving. This is a catchall table where all the rows are related to the "id" but are entered by different unrelated ...
    Bill MacArthurBill MacArthur
    May 25, 2013 at 7:19 am
    May 29, 2013 at 3:07 pm
  • I have one SELECT statement as follows: SELECT lpt_titulo as tmt_titulo, tmd_nombre as tmt_nombre, tmd_album as tmt_album, SUM(lpt_puntos) AS tmt_puntos FROM listas_pre_titulos INNER JOIN ...
    JORGE MALDONADOJORGE MALDONADO
    May 23, 2013 at 6:11 pm
    May 24, 2013 at 6:15 pm
  • I am running postgresql 9.2. I am assuming it would be a function of psql to right justify text, but I can't find any way to do this. Is there a way to right justify just one text column? Thanks Brian
    Brian SherwoodBrian Sherwood
    May 17, 2013 at 3:27 pm
    May 18, 2013 at 5:28 am
  • To summarize my question at the top, why is it that when I did the JOIN, the array_agg results reversed order? I had a function that ran the following query: SELECT timeslot, pollgrpid, ...
    George WoodringGeorge Woodring
    May 14, 2013 at 2:09 pm
    May 14, 2013 at 7:38 pm
  • Hi list, I have some problems with SERIALIZABLE isolation level, namely my users are plagued with concurrency errors. As of postgres 9.1 (which I'm running) there has been a change to SERIALIZABLE ...
    Marcin KrawczykMarcin Krawczyk
    May 13, 2013 at 9:22 am
    May 13, 2013 at 10:26 pm
  • I have an UPDATE query which performs several opertions in one table. UPDATE table01 SET field1 = (query1 may contain any field), field2 = (query1 may contain any field), field3 = (query1 may contain ...
    JORGE MALDONADOJORGE MALDONADO
    May 6, 2013 at 12:04 am
    May 6, 2013 at 9:32 am
  • It hit me today that a 1:n relationship can't be implemented just by a single foreign key constraint if n 0. I must have been sleeping very deeply not to notice this. E.g. if there is a table "list" ...
    Wolfgang KellerWolfgang Keller
    Apr 30, 2013 at 2:39 pm
    May 14, 2013 at 6:33 pm
  • Hi every one, I'm trying to do the follow: declare aCad text[][] begin ... execute 'aCad:=aCad array[['||var1||','||var2||']]' ... end; language plpgsql but I get the follow error: sintax erro near ...
    Mauricio CruzMauricio Cruz
    Apr 25, 2013 at 4:17 pm
    Apr 27, 2013 at 7:01 am
  • Hi, When i tried to delink the old tables i'm getting the following error NOTICE: SELECT COUNT(*) AS count from pg_tables where schemaname='fr' and tablename='check_deny_2013_04_17' CONTEXT: PL/pgSQL ...
    Shabeer eceShabeer ece
    Apr 23, 2013 at 8:01 am
    Apr 23, 2013 at 8:01 am
  • Hi, I am on postgresql 9.1 and use at table like CREATE TABLE timetable( tid INTEGER PRIMARY KEY, gid INTEGER REFERENCES groups(gid), day DATE, s TIME NOT NULL, --- start e TIME NOT NULL, --- end ...
    Wolfgang MeinersWolfgang Meiners
    Apr 22, 2013 at 10:19 am
    Apr 22, 2013 at 6:06 pm
  • Let´s suppose that I have a SELECT statement that joins more than one table and such a statement is order by fields that belong not only to the table in the FROM but also by fields in the tables that ...
    JORGE MALDONADOJORGE MALDONADO
    Apr 20, 2013 at 4:32 pm
    Apr 20, 2013 at 4:59 pm
  • I have a temporary table with columns zone_name, nodeid, nodelabel, nodegainedservice, nodelostservice Zone1, 3, Windows-SRV1, "2012-11-27 13:10:30+08", "2012-11-27 13:00:40+08" Zone1, 5, ...
    ChinnaobiChinnaobi
    Apr 19, 2013 at 3:41 am
    Apr 19, 2013 at 3:41 am
  • Hi, I am using Postgres DB with stand by database, configured with streaming in synchronized mode (each commit on primary DB waits for commit on secondary DB). Sometimes we suffer from network issues ...
    Sofer, YuvalSofer, Yuval
    Apr 18, 2013 at 3:41 pm
    Apr 18, 2013 at 4:38 pm
  • Hi, I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD newpassword it changes ok but then I can't login with my newpassword... It says authetication failed. My pg_hba.conf has ...
    Marcin KrawczykMarcin Krawczyk
    Apr 18, 2013 at 11:00 am
    Apr 19, 2013 at 8:13 am
  • Hello, i have try the following: -- Function: wetter.copy_ignore_duplicate(character varying) -- DROP FUNCTION wetter.copy_ignore_duplicate(character varying); CREATE OR REPLACE FUNCTION ...
    BastiBasti
    Apr 18, 2013 at 7:26 am
    Apr 18, 2013 at 1:48 pm
  • Hello, I'm trying to put together a fully contained runtime environment and am having trouble with fully qualified path names to dynamic library being included in _psycopg2.so (I'm on a Mac). See ...
    Thomas BurnettThomas Burnett
    Apr 16, 2013 at 6:42 pm
    Apr 16, 2013 at 6:42 pm
  • Hello, I'm working on designing a soft-delete scheme for our key entity-- there are 17 other tables that reference our key table via RI. Let's call the table "foo". I understand there are a couple ...
    Mark StosbergMark Stosberg
    Apr 16, 2013 at 4:24 pm
    Apr 18, 2013 at 12:01 pm
  • The following is my code and results: select '1' "num_ads", (case when r.region_code = 1000 then ( select count(*) from ( select userid from user_event_stg2 where userid in ( select userid from ...
    Tony CapobiancoTony Capobianco
    Apr 12, 2013 at 9:14 pm
    Apr 13, 2013 at 10:05 pm
  • Hi, The following when run in PostgreSQL 9.2.x seems to tell that if I have two tables A and B, such that if B inherits A, then, even if I don't have any rights on A, I can get an ACCESS EXCLUSIVE ...
    Robins TharakanRobins Tharakan
    Apr 12, 2013 at 8:59 pm
    Apr 12, 2013 at 9:09 pm
  • UPDATE tbl SET city=s.city_name FROM shp AS s WHERE ST_CONTAINS(s.city_geom,geom); With the code above i can add exact city to a GPS point. It runs about 45-50 min on 50 million rows. There are about ...
    AndroclosAndroclos
    Apr 11, 2013 at 4:38 pm
    Apr 11, 2013 at 4:38 pm
  • Hello, is there any best practice method how to create a foreign key that only allows values from those rows in the referenced table that fulfill an additional condition? First I present two pseudo ...
    Matthias NagelMatthias Nagel
    Apr 11, 2013 at 7:55 am
    Apr 12, 2013 at 7:52 pm
  • I have a table of artists with fields like the ones below: * Name * Birthday * Sex (male/female) Our application offers a catalog of artists where a user can select a range of birthdays and/or sex ...
    JORGE MALDONADOJORGE MALDONADO
    Apr 10, 2013 at 10:30 pm
    Apr 12, 2013 at 1:31 pm
  • Hi all, Can someone please point me to detailed documentation on how to secure/encrypt connections between PGBouncer and Postgresql database (version 8.4.3)? Thanks in advance! Bhanu M. Gandikota ...
    Bhanu MurthyBhanu Murthy
    Apr 10, 2013 at 6:06 pm
    Apr 10, 2013 at 6:17 pm
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppgsql-sql @
categoriespostgresql
discussions11,964
posts44,015
users6,062
websitepostgresql.org
irc#postgresql

Top users

Tgl: 3603 posts Josh Berkus: 1189 posts Richard Huxton: 970 posts Stephan Szabo: 690 posts Bruce Momjian: 496 posts Bruno Wolff III: 457 posts Peter Eisentraut: 421 posts Achill: 415 posts Michael Fuhr: 387 posts Stephan Szabo: 304 posts Christoph Haller: 293 posts Andreas Kretschmer: 273 posts Andrew Sullivan: 271 posts Jasiek: 270 posts Rajesh Kumar Mallah: 258 posts Pavel Stehule: 251 posts Scott Marlowe: 232 posts Jan Wieck: 223 posts Herouth maoz: 192 posts Aaron Bono: 190 posts
show more
Archives