blic | st_clip | {bool,float8,geometry,raster}
public | st_clip | {bool,int4,float8,geometry,raster}
public | st_clip | {bool,int4,geometry,raster}
public | st_clip | {bool,geometry,raster}
2015-11-19 18:38 GMT+01:00 Sandro Santilli :
> On Thu, Nov 19, 2015 at 06:25:46PM +0100, Lorenzo
:23 GMT+01:00 Sandro Santilli :
> On Thu, Nov 19, 2015 at 06:10:52PM +0100, Lorenzo Bottaccioli wrote:
> > Postgis installed by ubuntu repository, then
> >
> > createdb mydb
> > psql -d mydb -f postgis_comments.sql
> > psql -d mydb -f spatial_ref_sys.sql
> > ps
Sandro Santilli :
> On Thu, Nov 19, 2015 at 05:53:47PM +0100, Lorenzo Bottaccioli wrote:
> > SELECT extname, extversion from pg_extension;
> > extname | extversion
> > -+
> > plpgsql | 1.0
> > (1 row)
>
> [...]
>
> > POSTGIS="
SELECT extname, extversion from pg_extension;
extname | extversion
-+
plpgsql | 1.0
(1 row)
2015-11-19 17:40 GMT+01:00 Sandro Santilli :
> On Thu, Nov 19, 2015 at 02:00:05PM +0100, Lorenzo Bottaccioli wrote:
> > >
> > > How about these
>
> How about these:
>
> SELECT
> n.nspname, p.proname, array_agg(t.typname)
> FROM
> pg_proc p, pg_namespace n, pg_type t
> WHERE p.proname = 'st_bandisnodata'
>AND n.oid = p.pronamespace
>AND t.oid = any (p.proargtypes)
> GROUP BY
>n.nspname, p.proname, p.oid;
>
response:
ns
Hi,
(how) did you enable PostGIS for the database you're using ?
SELECT postgis_full_version();
--strk;
the reuslt of the query is:
POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
LIBJSON="UNKNOWN" RASTE
Hello,
I'm a new PostGis user so I might do some stupid questions. I have problem
with all most every ST function.
I'f I type this query:
*SELECT ST_BandIsNoData(rast) from mytable;*
I get this result
*ERROR: function st_bandisnodata(raster) does not exist*
*LINE 1: SELECT ST_BandIsNoData(ra