Comments (9)
The error you are getting is because the operator ->
is overloaded (in version 1.5.0) with the following possible operands
agtype -> agtype
agtype -> text
agtype -> int
In the query select properties->'ott' from ott_service_1.ott_company;
, 'ott'
is of the type unknown
and when such a type is provided as second argument to the operator ->, postgres chooses the operator agtype -> agtype
instead of agtype -> text
. And 'ott'
is not in valid agtype format (should be '"ott"'
), so you get an error.
You can read why specific operator is choosen when unknown
type is provided in the operator type resolution section here
from age.
@jrgemignani 1.5 ,1.4 Both were done in pg 14 version
from age.
@shinhanbyeol There appears to be something weird with the definition of ->
@Zainab-Saad Could you take a look?
Yes, looking into this
from age.
@shinhanbyeol What version of PG is this on, what version of PG did it previously work on?
from age.
@shinhanbyeol There appears to be something weird with the definition of ->
@Zainab-Saad Could you take a look?
from age.
psql-16.1-5432-pgsql=# select agtype_object_field(properties, 'name') from xyz._ag_label_vertex;
agtype_object_field
---------------------
"John"
(1 row)
psql-16.1-5432-pgsql=# select agtype_object_field_agtype(properties, 'name') from xyz._ag_label_vertex;
ERROR: invalid input syntax for type agtype
LINE 1: select agtype_object_field_agtype(properties, 'name') from x...
^
DETAIL: Expected agtype value, but found "name".
CONTEXT: agtype data, line 1: name
psql-16.1-5432-pgsql=#
psql-16.1-5432-pgsql=# select properties->'name' from xyz._ag_label_vertex;
ERROR: invalid input syntax for type agtype
LINE 1: select properties->'name' from xyz._ag_label_vertex;
^
DETAIL: Expected agtype value, but found "name".
CONTEXT: agtype data, line 1: name
psql-16.1-5432-pgsql=#
from age.
@Zainab-Saad Thank you!
from age.
This issue is stale because it has been open 45 days with no activity. Remove "Abondoned" label or comment or this will be closed in 7 days.
from age.
This issue was closed because it has been stalled for further 7 days with no activity.
from age.
Related Issues (20)
- Replace function "" is needed while using hybrid queries
- How to assign cypher result to pgsql variable? HOT 2
- Is data duplicated in parent and label/edge tables? What are the internals? HOT 2
- Age graph existance check function, something like "graph_exists" would be very nice HOT 7
- Could you please help with example, how to correctly use age_graph_stats function HOT 3
- Convert vertex:: or edge:: into text or jsonb types HOT 3
- Asking community for input regarding setup GraphQL API server to integrate with Apache Age Graph Database ecosystem, more questions on same inside HOT 1
- How to allow special characters in labels, backticks only works for property names. HOT 1
- Server crashes when executing SELECT * FROM cypher('ag_graph_3'...) HOT 3
- Problem with the WITH clause: Vertex assigned to variable <x> was deleted. HOT 2
- List comprehension in WHERE clause results in server process segmentation fault HOT 3
- Server crashes when executing SELECT agtype_build_map('null'::agtype, 1); HOT 3
- Server crashes when executing PREPARE property_ps(agtype)...
- MATCH Query Syntax issues HOT 3
- Simple query takes long time to run HOT 12
- In Greenplum, compiling the AGE plugin fails with the error: 'void value not ignored as it ought to be HOT 2
- load_labels_from_file produced duplicated graphId HOT 3
- cypher returned agtype cannot work with postgres IN clause HOT 1
- One more request for exist type function, this time for vertex and edge, previous was for graph. HOT 1
- is_valid_label fails to validate label type, while is_valid_label_name is calling into is_valid_label, should be the other way around HOT 11
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from age.