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     
This is my first shot at using postgresql's geometric functions I have a passel of lines defined by x1 y1 x2 y2 I created a table with type lseg and...
08-25-2011 08:08 PM
Samuel Gendler Go to last post
1 29
Hello I want to use the function st_offsetCurve but the pgadmin don't have and i don't find in the site of pgadmin. CAn anybody send...
08-25-2011 07:35 PM
Brent Dombrowski Go to last post
1 27
I have to deal with a table which contains: first_name surname email1 email2 .... and I would like to create a view which combines both email...
08-25-2011 03:46 PM
vipul shah Go to last post
6 27
Hi, there is a table that has among others a integer primary key "id" and another integer column "prio" as well as an integer "group_id". I'd like...
08-24-2011 10:15 AM
Tim Landscheidt Go to last post
2 25
Hi All, I'm trying to write a stored procedure /function to re-order a set of calendar months.I have a set of calendar months stored from January...
08-24-2011 10:07 AM
Tim Landscheidt Go to last post
3 29
Hello, I have a classic parent -> child relation (id, container_id) and I would like to find the full hierarchy for a child, something like A / \ B...
Julien Cigar
08-23-2011 10:39 AM
Julien Cigar Go to last post
1 29
Hi, I'm designing a new database. One of the table contains allowed IP ranges for a customer (Fields: customer_id, from_ip, to_ip) which is intended...
Herouth Maoz
08-23-2011 07:39 AM
Herouth Maoz Go to last post
10 40
Hi I have to rearrange the months according to the fiscal year i.e from April to march and use the same in the order by clause of a query. I have...
Enzen user
08-22-2011 07:58 PM
Gavin Flower Go to last post
2 23
Hi, I am trying to write a function that contains a cursor and iteratively calls itself. It is along the lines of, CREATE FUNCTON test(id integer)...
Kidd, David M
08-18-2011 12:15 PM
Tom Lane Go to last post
2 21
Hi, I have a query hitting a table of 25 million rows. The table has a text field ('identifier') which i need to query for matching rows. The...
08-17-2011 04:26 PM
Igor Neyman Go to last post
8 36
Hi everyone, I'm a bit lazy, or actually in a bit of a crunch. I added an audit recording a few months ago, but never really used it much, but...
M. D.
08-16-2011 07:35 PM
Jaime Casanova Go to last post
1 38
Hi, I have the following query: select ticket as ticket, time as created, author as reporter, cast(extract(epoch from (date 'now' - integer...
Janiv Ratson
08-16-2011 05:19 AM
Janiv Ratson Go to last post
7 25
Hi, With MS-SQL sever, there is a built-in utility function dbo.F_TABLE_NUMBER_RANGE which generates a list of number between the given range. For...
Yuan HOng
08-16-2011 01:21 AM
Pavel Stehule Go to last post
2 24
On Saturday, August 13, 2011 12:39:44 pm David Harel wrote: http://www.enterprisedb.com/docs/en/8.4/pgadmin/debugger.html -- Adrian...
Adrian Klaver
08-15-2011 02:53 PM
David Harel Go to last post
3 28
Hi all, This is probably quite simple. I want to calculate the ratio of each country (gwcode) which experiences a 1 in one column...
Andreas Forø Tollefsen
08-15-2011 09:49 AM
Andreas Forø Tollefsen Go to last post
4 31
Hi, Firstly; I'm not a developer, but a business developer and statistics guy. This means that I'm happy using "basic" selects to gather information...
08-12-2011 12:03 PM
Oliveiros d'Azevedo Cristina Go to last post
1 36
Hi all, Note: I'm happy to read howtos, tutorials, archived messages - I just haven't found anything that addresses this yet. I found a related...
Don Parris
08-11-2011 05:21 PM
Don Parris Go to last post
3 33
Strange... Tables have hidden columns but AFAIK, "name" is not one of...
Oliveiros d'Azevedo Cristina
08-09-2011 12:04 PM
Tom Lane Go to last post
2 30
Hi! I have strange issue with nested left-joins in postgresql... It's hard to explain, but easy to show =) here we are:
08-08-2011 03:14 PM
Carla Go to last post
3 33
Hi, Can you point me to any pages that explain the difference between using, say CHAR(8) vs VARCHAR(8) as the primary key for a table? Is there...
Raj Mathur
08-05-2011 08:43 AM
Jasen Betts Go to last post
4 25
Hi, Is there any built-in function/add-on module available in PostgreSQL, that converts a given "timestamp"/"timestamptz" value into its relative...
08-05-2011 05:07 AM
Gnanakumar Go to last post
5 26
select count(*) from table; count ------- 100 (1 row) is correct
Wes James
08-02-2011 10: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 01:48 PM
THOMPSON, JARED Go to last post
8 34
I have the following query Select PubArticleId, PubArticlePageXML from PubarticlePageXml x Inner Join Pubarticlepage p on...
Ozer, Pam
07-21-2011 07: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 01: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 10: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 07:40 PM
Craig Ringer Go to last post
5 33
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 02:20 PM
Kevin Crain Go to last post
18 36
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 11: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 03: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 06:48 PM
Gavin Flower Go to last post
7 29
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 05: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 03: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 05: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 10: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 09: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 12:45 PM
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 03: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 11: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 01: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 09: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 06: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 04: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 12:49 PM
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 09:01 PM
greg.fenton Go to last post
1 38
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 10: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 05:50 PM
Gavin Flower Go to last post
15 35
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 06: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 05: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 05:22 PM
Edgardo Portal Go to last post
6 23
Post New Thread

Display Options
Showing threads 451 to 500 of 3205
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.