dbTalk Databases Forums  

Sponsored Links

mailing.database.pgsql-sql mailing.database.pgsql-sql

Discuss in the mailing.database.pgsql-sql forum.

Post New Thread
Threads in Forum : mailing.database.pgsql-sql Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
select count(*) from table; count ------- 100 (1 row) is correct
Wes James
08-02-2011 09:13 AM
Wes James Go to last post
4 24
Hi, I just noticed that to_char() will "accept" invalid dates such as 2011-02-31 and "adjust" them accordingly: postgres=> select...
Thomas Kellerer
07-29-2011 12:48 PM
THOMPSON, JARED Go to last post
8 33
I have the following query Select PubArticleId, PubArticlePageXML from PubarticlePageXml x Inner Join Pubarticlepage p on...
Ozer, Pam
07-21-2011 06:28 PM
Ozer, Pam Go to last post
1 31
Hi, in postgreSQL (with LTREE extension) database I have the following table "comments": id BIGINT /* id */ article_id BIGINT /*article-id...
Ivan Polak
07-21-2011 12:31 PM
Ivan Polak Go to last post
7 29
Hi I would like to build Postgres from source with the visual studio 2010 compiler Is it supported? Is there any document which describes the...
Sofer, Yuval
07-20-2011 09:39 AM
Kevin Crain Go to last post
1 28
Hello, I've been trying to find out how to find out which sql was run to create a certain table. As I need this in a program which may access...
07-14-2011 06:40 PM
Craig Ringer Go to last post
5 32
Hi, I'm using postgresql 9 and I'd like to know if there is a way to "ask" if when I'm going to add a column, I'm exceeding the max number of...
Miguel Angel Conte
07-13-2011 01:20 PM
Kevin Crain Go to last post
18 33
I'm using Erlang and postgresql to build a web interface. When I create the query string I get something like: select * from table where...
Wes James
07-13-2011 10:36 AM
Wes James Go to last post
2 23
Jose Ig Mendez, 13.07.2011 09:36: Just leave out the quotes: select * from myTable where id_integer IN (1,2,3,4) --
Thomas Kellerer
07-13-2011 02:50 AM
Pavel Stehule Go to last post
1 23
Hi, I'm starting up a datawarehouse with patitioning. my etl processes write directly into the corresponding partitions instead of using...
Uwe Bartels
07-10-2011 05:48 PM
Gavin Flower Go to last post
7 28
hi all, can you tell me what is similar to like operator in mysql for postgresql hatem gamal -- Sent via pgsql-sql mailing list (pgsql-sql (AT)...
hatem gamal elzanaty
07-10-2011 04:11 PM
Scott Marlowe Go to last post
1 23
This is a little hard to explain, and I'm not sure if it's possible, but here goes. This is my query: select year, month, (select number from...
M. D.
07-06-2011 02:04 AM
Samuel Gendler Go to last post
1 26
Hi I have a stored function returning a record consisting of two field, and receiving as input a single identifier: CREATE FUNCTION calcvalues(IN...
07-05-2011 04:07 AM
gmb Go to last post
7 23
Hi, how can I remove a set of characters in text-columns ? Say I'd like to remove { } ( ) ' " , ; . : ! Of course I can chain replace ( replace (...
06-30-2011 09:43 PM
Andreas Go to last post
3 23
what is the best performance / best practices for frequently-used simple dml, for example, an insert 1. fast-interface 2. prepared statement calling...
chester c young
06-27-2011 08:40 AM
Pavel Stehule Go to last post
7 24
Hi, I have a SELECT statement that is using the regexp_split_to_table function as follows: .... and fk_topic in (select...
John Fabiani
06-23-2011 11:45 AM
John Fabiani Go to last post
1 28
the database collation is: en_US.UTF-8 drop table t1; create table t1 (recid int ,f1 varchar(20)); insert into t1 values (1,'a'); insert into t1...
Eyal Wilde
06-23-2011 02:18 AM
Pavel Stehule Go to last post
15 38
Hi, I've got a table with a couple of objects. Primary key object_id. There is a function that fetches some values from another table that relate...
06-20-2011 10:56 PM
Pavel Stehule Go to last post
1 22
Hi, I am totally new to PostgreSQL and this is my first script. Can anyone please help me with my following requirement I have script that returns ...
06-20-2011 12:05 PM
Ross J. Reedstrom Go to last post
4 27
hi, please see this code select aiah_number.aiah_number_id, aiah_number.aiah_number, lock.lock_status, rank.rank_value, approve.approve_status,...
hatem gamal elzanaty
06-20-2011 08:29 AM
Emi Lu Go to last post
2 19
Hi, I am new to postgre sql.I need to convert sqlite datbase to postgres database.i have nearly 15 table in my sqlite database in which 3 table...
sara vanan
06-16-2011 05:08 PM
Viktor Bojović Go to last post
1 33
I have a fact table that looks like this: dim1_fk bigint, time_fk bigint, tstamp timestamp without timezone value numeric(16,2) The tstamp column...
Samuel Gendler
06-15-2011 03:52 PM
Samuel Gendler Go to last post
1 21
Hi! Although I try for some time, I am not able to write an SQL-Query that can do the following: I have a very big table (let's call it "mytable")...
Jira, Marcel
06-15-2011 11:49 AM
Oliveiros d'Azevedo Cristina Go to last post
3 21
This is a follow-up to an old message by Tom Lane: http://archives.postgresql.org/pgsql-sql/2006-10/msg00080.php In ORMs like NHibernate, there are...
Patrick Earl
06-14-2011 08:01 PM
greg.fenton Go to last post
1 37
Can anybody tell me why this doesn't work? pgslekt=> CREATE SEQUENCE sources_source_id_seq START WITH (SELECT MAX(source_id) FROM sources); ERROR: ...
Leif Biberg Kristensen
06-14-2011 09:00 AM
Florian Weimer Go to last post
9 21
I have a table that, at a minimum, has ID and timestamp columns. Records are inserted into with random IDs and timestamps. Duplicate IDs are...
06-12-2011 04:50 PM
Gavin Flower Go to last post
15 34
Hey folks, I am still slogging away on my pet project, and I'm giving up - I need help from the experts to try to get this function working like I...
C. Bensend
06-11-2011 05:18 PM
C. Bensend Go to last post
2 22
Good morning, String array compare command, I forgot how to do it. E.g., create table z_drop(id varchar); insert into z_drop values('{"a1", "a2",...
Emi Lu
06-11-2011 04:59 AM
Jasen Betts Go to last post
1 25
hi, I have a log-table that stores events of users and projects like this ( user_id integer, project_id integer, ts timestamp, event_type integer...
06-09-2011 04:22 PM
Edgardo Portal Go to last post
6 22
Hello , do you know how to find a process that is locking a table ? I try to run a vacuum analyze , an it take a state of waiting , I canceled it...
manuel antonio ochoa
06-06-2011 06:21 PM
Scott Marlowe Go to last post
1 26
Is there a way in post-9.0 postgres for one session to determine if a LISTEN channel currently has a backend registered to receive notifications?...
James Robinson
06-01-2011 05:22 PM
Greg Sabino Mullane Go to last post
1 24
postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new install) I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and...
Dean le Roux
06-01-2011 10:00 AM
Dean le Roux Go to last post
4 29
Can procedural languages be used in rules? I didn't see any examples in the documentation that suggested something like this could be done using...
Kevin Crain
05-31-2011 09:46 AM
Kevin Crain Go to last post
1 23
Hi all, I need to write a function that totally empty a schema. So I have written a TRUNCATE statement for each table and set to 0...
05-30-2011 09:45 AM
Rob Sargent Go to last post
4 23
On Fri, May 27, 2011 at 9:15 AM, Emi Lu <emilu (AT) encs (DOT) concordia.ca> wrote: You asked about the "most efficient" but you didn't tell us...
Samuel Gendler
05-28-2011 02:58 AM
Piotr Czekalski Go to last post
1 20
A column contains location information, which may contain any of the following: 1) null 2) country name (e.g. "France") 3) city name, region name...
Tarlika Elisabeth Schmitz
05-26-2011 03:40 PM
Tarlika Elisabeth Schmitz Go to last post
15 39
Hello, To save pdf files into postgresql8.3, what is the best column type? bytea, blob, etc? Thank you, Emi --
Emi Lu
05-26-2011 01:07 PM
Ross J. Reedstrom Go to last post
13 31
Hi, Are there any guidelines for deciding whether to 1) create an enum data type or 2) create a table with the set of values and then have...
05-25-2011 06:08 PM
Seb Go to last post
2 25
Would you mind try: Select VehicleTrimAbbreviated, VehicleTrimAbbreviatedId from VehicleTrimAbbreviated Where vehicleTrimAbbreviated like...
Emi Lu
05-25-2011 05:18 PM
Ozer, Pam Go to last post
15 46
Hi, is there a reason why Not IN-performance is so poor in 9.0.4 compared to 8.4? Ty Jasmin
Jasmin Dizdarevic
05-25-2011 02:49 PM
Robert Haas Go to last post
9 23
I trying to get the next one : pg_dump -h -U User --format custom --inserts --verbose --file \"/root/Desktop/$name .backup\" --table...
manuel antonio ochoa
05-24-2011 09:07 PM
Craig Ringer Go to last post
2 24
The tools "pg_dump" & "pg_restore" are used to extract and re-create databases. Can be used for chores such as deploying from development to...
Basil Bourque
05-24-2011 08:56 PM
Craig Ringer Go to last post
5 24
I have a couple of questions regarding unnest. 1) If I issue a select statement "select unnest(vector1) as v from some_table", I cannot seem to use...
Karl Koster
05-21-2011 10:23 PM
Craig Ringer Go to last post
2 65
Hello, Postgresql8.3, tried: create table test(id, image oid); insert into test values(1, lo_import('apple.jpg')); ERROR: must be superuser to...
Emi Lu
05-18-2011 09:02 PM
Craig Ringer Go to last post
1 34
I have the following tables (individual seat allocation removed to make it simpler) create table coaches ( -- carriages c_id serial...
Gary Stainburn
05-18-2011 07:09 PM
David W Noon Go to last post
1 28
Hi, This probably reflects my confusion with how self joins work. Suppose we have this table: =# SELECT * FROM tmp; a | b ---+--- 1 | 2
05-17-2011 04:07 AM
Jasen Betts Go to last post
6 35
Hi, I am looking for a way to sort data returned from two tables with the first sort based on a field from table A and the secord sort based on the...
R. Smith
05-14-2011 07:58 AM
Oliver d'Azevedo Christina Go to last post
1 32
Hi all, I have this table id | date | score_count ----+--------------+------------- 13 | 1999-09-16 | 4 13 | 2002-06-27 | ...
Nguyen,Diep T
05-12-2011 05:18 PM
Samuel Gendler Go to last post
2 37
We are converting from Oracle to Postgres. An Oracle script contains this line: select replace(firstname,'"'), memberid, emailaddress from...
Tony Capobianco
05-11-2011 03:53 PM
Lew Go to last post
6 33
Hi, Maybe this is a dumb question but if I have a date field that contains a NULL will it show up when I ask for a where date range for the same date...
John Fabiani
05-10-2011 12:55 PM
Lew Go to last post
9 32
Post New Thread

Display Options
Showing threads 451 to 500 of 3185
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.