ST_LineFromWKB takes a well-known binary (WKB) representation of type ST_LineString and a spatial reference ID and returns an ST_LineString.
Oracle
sde.st_linefromwkb (wkb blob, srid integer)
PostgreSQL
st_linefromwkb (wkb bytea, srid integer)
In the following example, the lines of results have been reformatted for readability. The spacing in your results will vary according to your online display. The following code uses the ST_LineFromWKB function to create and insert a line from a WKB representation. The row is inserted into the sample_lines table with an ID and a line in spatial reference system 1 in WKB representation.
Oracle
CREATE TABLE sample_lines (id smallint, geometry sde.st_linestring, wkb blob);
INSERT INTO sample_lines (id, geometry) VALUES (
1901,
sde.st_linestring ('linestring (850 250, 850 850)', 0)
);
INSERT INTO sample_lines (id, geometry) VALUES (
1902,
sde.st_linestring ('linestring (33 2, 34 3, 35 6)', 0)
);
UPDATE sample_lines
SET wkb = sde.st_asbinary (geometry)
WHERE id = 1901;
UPDATE sample_lines
SET wkb = sde.st_asbinary (geometry)
WHERE id = 1902;
SELECT id, sde.st_astext (sde.st_linefromwkb (wkb,0)) LINE
FROM sample_lines;
ID LINE
1901 LINESTRING (850.00000000 250.00000000, 850.00000000 850.00000000)
1902 LINESTRING (33.00000000 2.00000000, 34.00000000 3.00000000, 35.00000000 6.00000000)
PostgreSQL
CREATE TABLE sample_lines (id integer, geometry st_linestring, wkb bytea);
INSERT INTO sample_lines (id, geometry) VALUES (
1901,
st_linestring ('linestring (850 250, 850 850)', 0)
);
INSERT INTO sample_lines (id, geometry) VALUES (
1902,
st_linestring ('linestring (33 2, 34 3, 35 6)', 0)
);
UPDATE sample_lines
SET wkb = st_asbinary (geometry)
WHERE id = 1901;
UPDATE sample_lines
SET wkb = st_asbinary (geometry)
WHERE id = 1902;
SELECT id, st_astext (st_linefromwkb (wkb,0)) AS LINE
FROM sample_lines;
id line
1901 LINESTRING (850 250, 850 850)
1902 LINESTRING (33 2, 34 3, 35 6)