summaryrefslogtreecommitdiff
path: root/contrib/cube/cube.sql.in
Commit message (Collapse)AuthorAgeFilesLines
* Backend support for autocommit removed, per recent discussions. TheTom Lane2003-05-141-2/+0
| | | | | | only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
* The attached patch provides cube with 4 functions for building cubesBruce Momjian2003-02-131-0/+16
| | | | | | | | | | | | | directly from float8 values. (As opposed to converting the values to strings and then parsing the strings.) The functions are: cube(float8) returns cube cube(float8,float8) returns cube cube(cube,float8) returns cube cube(cube,float8,float8) returns cube Bruno Wolff III
* When I made the cube(text) function for 7.3, I neglected to add aBruce Momjian2002-11-231-0/+2
| | | | | | | matching create cast command. The attached diff adds a create cast as assignment to cube.sql.in . Bruno Wolff III
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-181-147/+161
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* This is a comprehensive set of diffs (versus current CVS) that replaces thoseBruce Momjian2002-09-121-33/+58
| | | | | | | | | | | | attached to the same message with the Earth Distance patches. Recent changes include changing the subscript in one place I forgot in the previous bugfix patch. A couple of added regression tests, which should help catch this mistake if it reappears. I also put in a limit of 100 dimensions in cube_large and cube_in to prevent making it easy to create very large cubes. Changing one define in cubedata.h will raise the limit if some needs more dimensions. Bruno Wolff III
* The changes I have made are described in CHANGES. This was based onBruce Momjian2002-08-291-20/+50
| | | | | | | | | | | diffs to 7.3-devel and may not be applicable to 7.2. I have included a change covered by a previous bugfix patch I submitted (the problem with -.1 not being accepted by cube_in). It does not include a fix for the potential buffer overrun issue I reported for cube_yyerror in cubeparse.y. Bruno Wolff III
* Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane2002-08-221-18/+18
| | | | | | with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ...
* Fix potential buffer overrun in cube_out(), per report fromTom Lane2002-08-181-2/+2
| | | | Bruno Wolff.
* Replace ad-hoc insertions into pg_opclass and friends with CREATETom Lane2002-07-301-157/+23
| | | | OPERATOR CLASS commands. Further tweaking of documentation for same.
* Opclasses live in namespaces. I also took the opportunity to createTom Lane2002-04-171-1/+3
| | | | | | | an 'opclass owner' column in pg_opclass. Nothing is done with it at present, but since there are plans to invent a CREATE OPERATOR CLASS command soon, we'll probably want DROP OPERATOR CLASS too, which suggests that a notion of ownership would be a good idea.
* Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions inTom Lane2001-08-211-65/+98
| | | | | | | | | | | | | | | | | | | | pgsql-hackers. pg_opclass now has a row for each opclass supported by each index AM, not a row for each opclass name. This allows pg_opclass to show directly whether an AM supports an opclass, and furthermore makes it possible to store additional information about an opclass that might be AM-dependent. pg_opclass and pg_amop now store "lossy" and "haskeytype" information that we previously expected the user to remember to provide in CREATE INDEX commands. Lossiness is no longer an index-level property, but is associated with the use of a particular operator in a particular index opclass. Along the way, IndexSupportInitialize now uses the syscaches to retrieve pg_amop and pg_amproc entries. I find this reduces backend launch time by about ten percent, at the cost of a couple more special cases in catcache.c's IndexScanOK. Initial work by Oleg Bartunov and Teodor Sigaev, further hacking by Tom Lane. initdb forced.
* 1. null-safe interface to GiSTBruce Momjian2001-08-101-16/+16
| | | | | | | | | | | | | | (as proposed in http://fts.postgresql.org/db/mw/msg.html?mid=1028327) 2. support for 'pass-by-value' arguments - to test this we used special opclass for int4 with values in range [0-2^15] More testing will be done after resolving problem with index_formtuple and implementation of B-tree using GiST 3. small patch to contrib modules (seg,cube,rtree_gist,intarray) - mark functions as 'isstrict' where needed. Oleg Bartunov
* Gene Selkov's CUBE datatype (GiST example code)Tom Lane2000-12-111-0/+337