[SQL] ascii-betical sort order?

rious). It may not be terribly important, but it'd be useful to know in case it actually is an issue. I couldn't find any clear answer searching online. Thanks, Peter -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] ascii-betical sort order?

king for. I'll look at this when I have a bit more time. Thanks, Peter -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] A Question

-10-23'; > Also tell me how to retreive all records from database where field which is > date time is null I am working on ASP and backend as ms-ACCESS SELECT * FROM table WHERE datetime_field is null; -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED]

Re: [SQL] aliases break my query

n SELECT are a good idea. We invariably get a question like this every week and invariably the answer is "if you give a table an alias you *must* refer to it by that alias". (I'm sure Tom has this reply automated by now.) I claim the only thing that buys is confusion for very little conv

[SQL] POSTGRESQL and PERL?

Hi- I'm a newbie at postgresql and was working on sorting by category. What my question is, how do you sort by category when using a variable. For instance, you can sort by name in perl by doing: $sqh = $dbh->prepare(q{select name from company order by name;}); $sqh->execute(); but what i

Re: [SQL] Inheritance

ot;a", period. I know this doesn't help in practice, though. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [SQL] 7.0 weirdness

Hi Jeff! I think you need a solution, and not explains... Tom, and the others told the truth. You missed this query. > gid is unique.. it's a serial.. I give you two ways: 1) gid __realy__ unique -> DISTINCT is unnecessary. SELECT gid FROM members -- ... etc 2) gid not unique -> DISTINCT

[SQL] Re: [ADMIN] create view security

Wallingford, Ted writes: > I am using 6.3 in this case. I'm sorry but that is pre-historic era around here and no one really remembers what the problems might have been back then (other than that they were surely plenty). Upgrading might be your best bet on all fronts. -- Peter Ei

Re: [SQL] SQL'92 web resources

Bruce Momjian writes: > Shouldn't we have links to these on our web site? SQL92 is yesterday's news. Find your SQL99 documents at: ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/ (Though I'm unsure about the legality of these.) -- Peter Eisentraut Ser

Re: [SQL] LIKE vrs ~~

difference at all. (Only the extra cycles to convert LIKE to ~~ internally.) If you're comparing true case-insensitive matching to using UPPER, then the latter is probably faster but doesn't really do the same thing. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROT

Re: [SQL] Client Logging

ion that takes a string argument and calls elog. is probably reasonable. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [SQL] Outer join in postgresql

On Mon, 12 Jun 2000, Patrick Kay wrote: > I am looking for a way run an outer join in psql. Can anyone help? > > Informix has an "OUTER" keyword. I don't see anything like this in the docs > for psql. > > Thanks much. > -Pat Kay > Hmmm... I don't now the exact definition of outer join. I f

[SQL] Re: Simple search question

appen? In JDBC I would turn off auto-commit mode, then commit after the SELECT. This should ensure that the sequence doesn't get incremented between INSERT and SELECT. > > Thanks, > Alex Hope this helps, Peter

[SQL] Re: [BUGS] Some problem with inet type on PostgreSQL-7.0

> switch01.tor | 1 | 127.0.0.2 | 255.0.0.0 > switch01.tor | 2 | 127.0.0.3 | 255.0.0.0 > switch01.tor | 3 | 209.250.155.8 | 255.255.255.224 > (2 rows) > > > 127.0.0.2 | 255.0.0.0 and 127.0.0.3 | 255.0.0.0 - it's

Re: [SQL] find the number of rows for each table

t (medias.media_id)), count(distinct > (contacts.contact_id)) from medias, contacts WHERE medias.media_id = > contacts.media_id AND medias_categories.media_id = medias.media_id AND > medias_categories.categorie_id = 1 > - > ERROR: parser:

Re: [SQL] Database Transfer

Craig May writes: > I have two servers running pgsql. Is there a command to transfer the > databases > between them? pg_dump and psql. "Back up" one database and "restore" it on the other server. Don't even think about moving files around. :) -- Peter Eise

Re: [SQL] Altnerate Column Return Names

esult to return > > table1.id | table1.name | table1.data | table2.id | ,,, > ---+-+-+---+- ... select table1.id as "whatever you want", table1.name as "whatever you want", table1.data as "something", ... You get the idea.

Re: [SQL] Search for underscore w/ LIKE

s are not special. Maybe we could offer that as well. blah ~ r'.+\..+' -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [SQL] Select by priority

me person table, but remember that you need to group by every non-aggregate column in the select list. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [SQL] Database authentication and configuration

red. > In addition, I'd like to default various database settings when I > connect to the database. Where is the place to do such configuration? That depends on the nature of the various settings. You can put commands into ~/.psqlrc that will be executed when psq

Re: [SQL] What's ETA for read/write Views?

chine going to > figure out what you want an update on the view to do? The SQL standard has pretty precise rules for when views are updatable and how. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [SQL] Where Can I find JDBC driver.

knows it's taking an extraordinarily long time to move servers so the following link will also work while the DNS catches up: http://jdbc.postgresql.org/download.html NB: Most of the links will fail, but the .jar files should work. As on how to use the jar file, check the Interfaces list archive

Re: [SQL] Image insertion by using BLOB

ly works on the servers filesystem. > > If possible , how ? You need to use the fastpath/largeobject api's to send the image over the network connection. There's 2 C & 1 Java examples included in the source showing this. Peter > > > -som > > > >

Re: [SQL] CHAR or VARCHAR

lt in slower performance. I rarely index a table if there are many inserts/updates. So char vs. varchar Peter --- "Reality is that which, when you stop believing in it, doesn't go away". -- Philip K. Dick --

Re: [SQL] CHAR or VARCHAR

On 22 Mar 2001, at 10:05, Tom Lane wrote: > There is *no* performance advantage of CHAR(n) over VARCHAR(n). > If anything, there is a performance lossage due to extra disk I/O > (because all those padding blanks take space, and time to read). > > My advice is to use CHAR(n) when that semanticall

Re: Calling Java from psql (was Re: [SQL] requesting help)

y big. Having it talk to an already running JVM is the best option. > Also, why am I getting "not subscribed messages", I am subscribed since > I'm replying to a message that was sent to me!! I'm getting that with the patches list as well. Peter > On Thu, 29 Mar 2

[SQL] use of arrow keys to traverse history

in my ignorance leads me to believe that postgres will run in the bash shell and so I expect the use of arrow keys or command history. Clues appreciated. Peter --- "Reality is that which, when you stop believing in it, doesn't go away". --

[SQL] must I create the function check_primary_key ?

RIGGER but it doesn't work for me. Thanks, Peter All idioms must be learned. Good idioms only need to be learned once. --Alan Cooper ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [SQL] must I create the function check_primary_key ?

> On Wed, 25 Apr 2001, Peter J. Schoenster wrote: > > > I want to use this referential integrity etc. that I've never used ..snip.. > > CREATE TRIGGER employer_id_exists > > BEFORE INSERT OR UPDATE ON company_profile FOR EACH > > ROW > > EXECUTE

[SQL] making queries more effecient

Hi. I have this query that I have been trying to reduce to a single statement, but haven't figured out how. Am I missing something? CREATE TEMP TABLE temp20561149207391 AS SELECT DISTINCT ON ("VisitorID") "VisitorID","Type" FROM "ProgramEvent" WHERE "ProgramID" = 10 ORDER BY "VisitorID","Created"

[SQL] how can I improve the speed of this query

ce I have a key for Visitor.ID, I don't understand why its doing a sequential scan on that table... Any advice would be greatly appreciated! Thanks Peter EXPLAIN SELECT "Visitor"."Created", "Visitor"."Updated", "Ti

[SQL] Savepoints and SELECT FOR UPDATE in 8.2

I have a client application that needs: SELECT a set of records from a table and lock them for potential updates. for each record make some updates to this record and some other records in other tables call some call a function that does some application logic that does not access the da

[SQL] LIMIT question

I need to use a LIMIT count in a query but I also need to know how many rows the query itself would yield without the limit. I can do this inside a transaction like this BEGIN SELECT COUNT(*) from table1 where blah; select * from table1 where blah LIMIT 1000; COMMIT Now I can give some feedback l

[SQL] looking for example of inserting into a view

I can't seem to find an example I vaguely remember seeing when I was originally learning about INSERT rules and views. This example features a view that is an outer join of several tables. The example shows how to generate a CSV file of the data in the view and then loading the data into the origi

<    1   2   3   4   5