Question : I created a user-defined type in a PostgreSQL 9.2 database and am trying in the SELECT statement to […]
Tag: composite-types
Return type of JOINing stored procedure – PostgreSQL
Question : Is it possible to express return type of stored procedure that returns joined tables using table type of […]
Good layout of 3d point data for spatial queries in Postgres?
Question : Like shown in another question, I deal with a lot (>10,000,000) entries of points in a 3D space. […]
why is mysql not using the composite index on my query?
Question : Here is my query. select user_id, sum(user_points.points) overallpts, username from user inner join user_points on user.user_id = user_points.user_id […]
PostgreSQL – Return type and EXECUTE QUERY
Question : My function returns a setof composite type, however the RETURN EXECUTE seems to return some other unknown type: […]
How to set/get a field of a nested composite type variable?
Question : For example: create type t1 as (a int2, b text, c boolean); create type t2 as (a t1, […]
Postgres FOREACH array as composite type
Question : I’m trying to loop over an array with two types as a composite type, but it seems that […]
Pass an array or record to a function in PostgreSQL?
Question : I have a task to pass arrays, records, and in some cases array of records as a parameter […]
Column does not exists when accessing inner type field in ORDER BY
Question : In PostgreSQL 9.4 I have two types: CREATE TYPE a_schema.type_child { an_order smallint } CREATE TYPE a_schema.type_parent { […]
Using a type in place of a column definition list?
Question : Running the below, I get “a column definition list is required for functions returning “record””. SELECT * FROM […]