Re: [NOVICE] Re: [GENERAL] VACUUM AND VACUUM ANALYSE
On Wed, Nov 08, 2000 at 05:51:52PM +, Oliver Elphick wrote: > =?iso-8859-1?Q?Micka=EBl_Jouanne?= wrote: > >Hello ! > > > >I want to do a VACUUM ANALYSE on some tables but when i do : > > > >EDEN=> VACUUM ANALYSE cvdb; > >ERROR: parser: parse error at or near "cvdb" > > > >But cvdb is a working table. > > > >Does someone have a idea of the error ? > > > It's "ANALYZE" (those Americans just don't know how to spell!) "Forgive him, Caesar, for [Britannus] is a barbarian, and thinks that the customs of his tribe and island are laws of nature." George Barnard Shaw, "Julius Caesar" (quoted and cited from memory) :-) -- -- C^2 No windows were crashed in the making of this email. Looking for fine software and/or web pages? http://w3.trib.com/~ccurley PGP signature
[GENERAL] Re: [NOVICE] installation question
On Sun, Apr 09, 2000 at 11:43:35PM -0400, Vipin Samtani wrote: -> hi, -> i am a novice user running Red Hat Linux Server 6. -> what files do i need to download to install PostGreSQL? -> vipin -> Have you checked to see if there is an RPM package on your RH CD? -- -- C^2 No windows were crashed in the making of this email. Looking for fine software and/or web pages? http://w3.trib.com/~ccurley
Re: [GENERAL] Case insensitive "contains" search
Ulf Mehlig wrote: > In my opinion, the regexps are much more powerfull compared to "like > '%anything'"-statements; but the regular expression syntax is a little > bit weird, and if you have a look in the docs of programs which > heavily depend on regexps (perl, grep, emacs, ...) you'll find some > nice annoying little differences in "to-quote-or-not-to-quote" > sections ... Is there a text that describes the RE usage in PostgrSQL? I'd like to know how to do more complicated expressions, like, "^(((charl|jam)es)|(bob))", which should match a field that begins with "charles", "james", or "bob". Yes, it can be rewritten, but I have yet to see a demo of how to use parenthetical RE's in PostgreSQL. What I want to do is provide the user with the ability to use RE's ala egrep. It would be really sweet to see perl RE's in there. I've written a couple of times about this and I've gotten answer as to how to rewrite a particular RE to work with PostgreSQL, but I would like a more general description. Can the backend be easily linked with a different regexp library like GNU's? BTW, all of my comments are referencing 6.3.2. -- Charles Curley, Staff Engineer Computer Integrated Manufacturing Lockheed Martin Ocala Operations
[GENERAL] Regex problems
I'm running 6.3.2 on RedHat 5.0. I have the following table: Table = employees +-+--+---+ | Field | Type | Length| +-+--+---+ | id | char() not null | 8 | | first | char() | 20 | | mi | char() | 1 | | last | char() | 20 | | suffix | char() | 8 | | dept | char() | 8 | | phone | char() | 20 | | mp | char() | 8 | | email | char() | 64 | +-+--+---+ If I do the following: select "dept", "last", "first" from "employees" where "last" = 'Curley'; I get my information. If I do: select "dept", "last", "first" from "employees" where "last" ~ 'C*'; I get the entire table's worth of matches (883) regardless of what the last name is. Examples that are matched: dept |last |first ++--- A5A0 |Achey |Karen A5M2 |Achey |Lonny A75P |Ackley |Roger A847 |Adair |Ethel A84P |Adams |Denise A654 |Adams |Gary ... A847 |Young |Ronald A75P |Younger |Curtis A847 |Zappia |Sandy A850 |Zrinski |Beverly A5MP |Zygmant |Michael (883 rows) Trying the following: select "dept", "last", "first" from "employees" where "last" ~ 'Cu*'; Produces fewer hits (74) but gives wrong values again, basically returning all the employees with a last name that begins with 'C' as well a few strange matches at the end with "last" values of 'Del Castillo', 'Moore', and 'O''Connor'. Telling me to use LIKE isn't what I'm hoping to get here. My searches will require that I use regular expressions, I just toned them down for the examples. -- Charles Curley, Staff Engineer Computer Integrated Manufacturing Lockheed Martin Ocala Operations