In article ,
Ty Busby writes:
> I have a table that stores a very large starting number called
> epc_start_numeric and a quantity. I've apparently built the most
> inefficient query possible for doing the job I need: find out if any
> records overlap. Imagine the epc_start_numeric + quantity
>
In article ,
Joel Stevenson writes:
> select tally_table. tally_mon, met.datum
> from (
> select distinct date_trunc( 'month', '2011-06-01'::date + tally_day )::date
> as tally_mon
> from generate_series( 0, ( select current_date - '2011-06-01'::date ) ) as
> tally_day
> ) as tally_table fu
In article <1318661510830-4904685.p...@n5.nabble.com>,
"maya.more" writes:
> I have a table with Date and unit column. . I want to find sum of unit column
> considering 3 days each
> User will specify start and enddate
> Eg
> DateUnit
> 10/1/2011 1
> 10/2/2011 2
> 10/3/201
In article ,
James Bond writes:
> hi, i am fairly new in postgresql, so if anyone can help me would be great
> if i simply do:
> select ver_no
> from version
> order by ver_no
> the result will be something like this:
> .1.3.1
> .1.3.2.5.
> .1.4.1.7.12
> .1.4.11.14.7.
> .1.4.3.109.1.
> .1.4.8.
In article <1343d11c-6f58-4653-8ea8-837c01e61...@unicell.co.il>,
Herouth Maoz writes:
> On 22/08/2011, at 01:19, Harald Fuchs wrote:
>> In article ,
>> Herouth Maoz writes:
>>
>>> Hi,
>>> I'm designing a new database. One of the table cont
In article ,
Herouth Maoz writes:
> 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 to check -
> if an incoming connection's originating IP number falls within the range, it
> is identifie
In article <1309762075448-4549140.p...@n5.nabble.com>,
gmb writes:
> Hi I have a stored function returning a record consisting of two field,
> and receiving as input a single identifier: CREATE FUNCTION calcvalues(IN
> itemid VACHAR, OUT calcval1 NUMERIC, OUT calcval2 NUMERIC) RETURNS
> record...
In article ,
Jasen Betts writes:
> On 2011-05-14, Seb wrote:
>> Hi,
>>
>> This probably reflects my confusion with how self joins work.
>>
>> Suppose we have this table:
>> If I want to get a table with records where none of the values in column
>> b are found in column a, I thought this shou
In article <4cc4d3e2.7090...@gmx.net>,
Andreas writes:
> Hi,
> I'm wondering if there was a clever way to find parts of a numeric
> string in another table.
> There is a table that holds city-codes and city-names. City-code would
> be the part of a phone number that identifies the city.
> Over he
In article <4bfd5bc0.90...@unipex.it>,
Michele Petrazzo - Unipex writes:
> Hi list,
> I have two table that are so represented:
> t1:
> id int primary key
> ... other
> t2:
> id int primary key
> t1id int fk(t1.id)
> somedate date
> ... other
> data t1:
> 1 | abcde
> 2 | fghi
> data t2:
> 1 |
In article <987929295d1345b5bce249f42730c...@marktestcr.marktest.pt>,
"Oliveiros" writes:
> Hi, Thomas.
> I believe it is because of your WHERE clause, which is filtering out the nulls
> from hp table.
> According to
> WHERE
> hp.poste_idposte = 275
> You only want registers that have hp.post
In article <4bbed49d.7080...@krap.dk>,
Svenne Krap writes:
> Hi .
> My problem resembles this:
> I have the following (simplified) tables
> 1) create table account ( id serial, name varchar, parent_id int4
> references account, primary key (id))
> 2) create table transaction (id serial, accoun
In article ,
"Oliveiros C," writes:
> Dear All,
> I have a table with host names and some happen to be numeric IPs.
> I would like to be able to filter out the later.
> Is there any function pre-defined in the system that can test a particular
> text
> type value to see if it is a numeric ip
In article <28855.1260486...@sss.pgh.pa.us>,
Tom Lane writes:
> Harald Fuchs writes:
>> That being said, I still think that PostgreSQL could do better - how
>> about naming expression columns so that they are distinct from column
>> names?
> Even though the rul
In article <25983.1260468...@sss.pgh.pa.us>,
Tom Lane writes:
> The SQL standard says the default name for any output column other
> than a simple column reference is implementation-dependent. I think
> our implementation involves looking at the default value for a CASE.
Thanks for the clarific
In article ,
Harald Fuchs writes:
> The other users for one address are gone. Does anyone know why?
Update: they are not gone, but they've moved to the end of the result
set. Apparently the CASE expression is named "adr" unless named
otherwise, and the result set is sorted
I have a table like this:
CREATE TABLE tbl (
host text NOT NULL,
adr ip4 NOT NULL,
usr text NOT NULL
);
(ip4 is from the ip4r contrib module)
and I want the number of entries per address and per user:
SELECT adr, usr, count(*)
FROM tbl
WHERE host = ?
AND adr <<= ?
GRO
In article <200911300708.12397.akla...@comcast.net>,
Adrian Klaver writes:
> From a quick look it would seem the easiest solution would be to change the
> search_path in:
> citext.sql.in
> uuid-ossp.sql.in
> These files are found in the respective contrib directories. Uninstall the
> modules.
In article <4a71f9cb.9050...@encs.concordia.ca>,
Emi Lu writes:
> Good morning,
> I have a currency table (code, description).
> Example values:
> ADF | Andorran Franc
> ... ...
> ANG | NL Antillian Guilder
> AON | Angolan New Kwanza
> AUD | Australian Dollar
> AWG | Aruban Florin
> BBD |
In article ,
"Philippe Lang" writes:
> Thanks for your answer. Si there a built-in function that would allow
> generating the sort path based on the value of the lookup column,
> instead of the id, which has no meaning at all?
> If yes, we would get instead:
> depth | id | lookup | parent_id
In article <24680.1245784...@sss.pgh.pa.us>,
Tom Lane writes:
> Joshua Tolley writes:
>> Primary keys are NOT NULL and UNIQUE. You can't have null values in a primary
>> key.
> On reflection I think the OP's beef is that we complain about this:
> regression=# create table t (f1 int null not nu
I tried to throw some invalid SQL to PostgreSQL and found its reaction
confusing:
$ psql test
psql (8.4beta2)
Type "help" for help.
test=# CREATE TABLE t1 (
test(# id serial NOT NULL,
test(# name text NOT NULL,
test(# PRIMARY KEY (id)
test(# );
CREATE TABLE
te
In article <162867790905180410n670062b0ud2d7fdd0e652...@mail.gmail.com>,
Pavel Stehule writes:
> Hello
> postgres=# create or replace function sum_items(bigint[]) returns
> bigint as $$ select sum($1[i])::bigint from
> generate_series(array_lower($1,1), array_upper($1,1)) g(i)$$ language
> sql im
In article <87ljstm4eq@oxford.xeocode.com>,
Gregory Stark writes:
> "Bart Degryse" writes:
>> Hi,
>> I have a text field with data like this: 'de patiënt niet'
>> Can anyone help me fix this or point me to a better approach.
>> By the way, changing the way data is put into the field is
>> u
In article <[EMAIL PROTECTED]>,
Tarlika Elisabeth Schmitz <[EMAIL PROTECTED]> writes:
> PRODUCT table :
> A B C
> 100 200 300
> 100 200 301
> 100 205 300
> 100 205 301
> NAVIGATION table
> A B C #ITEMS
> 100 200 300 5
> 100 200 301 6
> My query needs to return
> 100 205 300 #items
> 100 205 30
In article <[EMAIL PROTECTED]>,
"Michael Lourant" <[EMAIL PROTECTED]> writes:
> Type Safety
> Enumerated types are completely separate data types and may not be compared
> with each other.
...
> An Alternative Way To Do The Same
> Instead of using an enum type we can set up a CHECK CONSTRAINT
In article <[EMAIL PROTECTED]>,
"Robins Tharakan" <[EMAIL PROTECTED]> writes:
> While we could always check for the query performance reasons, I
> rather think that this is an overkill for the purpose of mere line
> numbers.
> If such queries don't change frequently, you could be better off
> usi
In article <[EMAIL PROTECTED]>,
"Jamie Tufnell" <[EMAIL PROTECTED]> writes:
> Hi,
> I am storing a log of HTTP requests in a database table (including IP
> address):
> http_log: id(PK), path, time, ip
> I have another table that contains CIDR ranges and names for them:
> network_names: id(PK),
In article <[EMAIL PROTECTED]>,
"Chuck D." <[EMAIL PROTECTED]> writes:
> On October 23, 2007 08:51:18 pm you wrote:
>>
>> I got it to work with your sample data by using the COPY command as
>> follows: COPY geo.orig_city_maxmind
>> FROM '/home/www/geo/DATA/MAXMIND.com/cities_no_header.txt'
>> CSV
In article <[EMAIL PROTECTED]>,
"Jamie Tufnell" <[EMAIL PROTECTED]> writes:
> Hi list,
> I have a many-to-many relationship between movies and genres and, in the link
> table I have a third field called which orders the "appropriateness" of the
> relations within each movie.
> For example:
> mo
In article <[EMAIL PROTECTED]>,
"CN" <[EMAIL PROTECTED]> writes:
> select * from x1;
> name | hobby
> ---+--
> John | music
> John | arts
> Bob | arts
> Bob | music
> Rocky | computer
> Steve | arts
> Steve | football
> Tom | computer
> Tom | music
> (9 rows)
In article <[EMAIL PROTECTED]>,
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> I need to do:
> NOW() + '2 day'::interval
> where 2 is a variable ...
> if I do:
> NOW() + '? day'::interval
> it, of course, takes the ? as a literal ... so is there some way I can
> do this such that I can do t
In article <[EMAIL PROTECTED]>,
Bruce Momjian writes:
> Magdalena Komorowska wrote:
>> Hi,
>> I hale a problem with counting interwal and I can't find what to do with
>> this.
>> I have two fields in the table:
>> Column | Type | Modifiers
>> -+-+---
>> d
In article <[EMAIL PROTECTED]>,
george young writes:
> [PostgreSQL 7.4RC2 on i686-pc-linux-gnu](I know, I know... must upgrade soon)
> I have a table mytable like:
> i | txt
> ---+---
> 1 | the
> 2 | the
> 3 | rain
> 4 | in
> 5 | mainly
> 6 | spain
> 7 | stays
> 8 | mainly
> 9 |
In article <[EMAIL PROTECTED]>,
"alessandra de gregorio" <[EMAIL PROTECTED]> writes:
> Hi,
> What function should I use to get a serial number, together with my results,
> from a query?
> Ex. Of output I want:
> 1 ooo pp ij
> 2 hou joo iu
> 3 bhi ft yh
In article <[EMAIL PROTECTED]>,
MaXX <[EMAIL PROTECTED]> writes:
> How can I "merge" this
> gday,count_udp,count_tcp
> '2005-10-20','','2'
> '2005-10-20','3',''
> '2005-10-21','','1'
> '2005-10-21','5',''
> into that:
> gday,count_udp,count_tcp
> '2005-10-20','3','2'
> '2005-10-21','5','1'
> in
In article <[EMAIL PROTECTED]>,
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Fri, 2 Sep 2005, [ISO-8859-2] Graf László wrote:
>>
>> CREATE FUNCTION test_verif() RETURNS trigger AS $test_verif$
>> BEGIN
>> NEW.id := select nextval('test_azon_seq');
> I think you want to remove select here, you'
In article <[EMAIL PROTECTED]>,
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Presumably,
> colname ~ '^[A-Za-z]*$'
> If you want to be independent of locale issues, then you'd have to enumerate
> all the letters instead of using a range specification.
How so? I thought character ranges
In article <[EMAIL PROTECTED]>,
Dawid Kuroczko <[EMAIL PROTECTED]> writes:
> Use
> EXPLAIN SELECT * FROM yourcountedtable;
> Planner seems to track estimated statistics on-the-fly. :)
> You can even wrap EXPLAIN SELECT in a pgsql function if you
> need it.
Do you know how to do that? A functio
In article <[EMAIL PROTECTED]>,
Ragnar Hafstað <[EMAIL PROTECTED]> writes:
> 20 ms does not sound like a big problem.
> if 20 ms is really too much for you, and add_date IS a timestamp,
> you might think about adding a date column , maintained
> by triggers of by your application, and add an inde
In article <[EMAIL PROTECTED]>,
Mischa <[EMAIL PROTECTED]> writes:
> I've got a similar request for other objects that do/do not exist.
> Maybe it's just that I got lazy using MSSQL, but it sure was convenient
> to have:
>IF object_id('WorkTable') IS NULL
>CREATE TABLE WorkTable(...
>
In article <[EMAIL PROTECTED]>,
Kretschmer Andreas <[EMAIL PROTECTED]> writes:
> Hi,
> I have a table with this columns: machine, date and area.
> Now i need a view with machine an week, calculated from date, and
> sum(area), where date between CURRENT_DATE and now+N days.
> Okay, this is not the
In article <[EMAIL PROTECTED]>,
Theo Galanakis <[EMAIL PROTECTED]> writes:
> Has anyone been able to export and import a tab delimited file from mysql to
> postgres successfully?
> This is my dilemma which I have posted on mysql sites with no response,
> however postgres users may have come across
In article <[EMAIL PROTECTED]>,
"Michael L. Hostbaek" <[EMAIL PROTECTED]> writes:
> Hello,
> I've got a table in an oracle database with approx. 10 records, that
> I'd like to put into a table in a postgresql database. (This should be
> done a couple of times per week)
> I have written a sho
44 matches
Mail list logo
